In one in every of my earlier posts I defined find out how to use Energy BI on high of your SSAS Multidimensional utilizing Information Import State of affairs. You too can discover definitive clarification about “Managing Evaluation Providers Multidimensional Mannequin” right here. On this put up I present you find out how to join reside your SSAS Multidimensional mannequin with Energy BI. “Join Reside SSAS Multidimensional” means making a Direct Connection from Energy BI Desktop to your SSAS Multidimensional occasion.
As it’s a direct connection you’ll have the ability to see/use the next SSAS Multidimensional objects:
- Cubes
- Views
- Measure Teams
- Measures
- Dimensions
- Dimension Attributes
- Hierarchies together with Dad or mum Youngster
On this put up you’ll be taught:
- Tips on how to join reside from Energy BI Desktop to SSAS Multidimensional
- Creating reviews utilizing SSAS objects like hierarchies
- Publishing your reviews from Energy BI Desktop to Energy BI Service
To have the ability to efficiently create and publish your reviews utilizing Energy BI Desktop on high of SSAS Multidimensional you’ll require:
- The most recent model of Energy BI Desktop (Present model is 2.31.4280.361 64-bit (January 2016))
- On-premises Information Gateway
- Managing SSAS Multidimensional Information Supply from Energy BI Service
- Energy BI Service Professional Account
- SQL Server 2012 Evaluation Providers SP1 CU4 or later (Enterprise or Enterprise Intelligence editions solely)
Please keep in mind that you will need to have the most recent model of Energy BI Desktop. The present model on the date of publishing this text is 2.31.4280.361 64-bit (January 2016).
- Open Energy BI Desktop
- Click on Get Information
- Click on “SQL Server Evaluation Providers Database”
- Click on Join
- Enter “Server” and “Database” names
Observe: As I discussed earlier you should have SQL Server 2012 Evaluation Providers SP1 CU4 or later. So if you happen to’re attempting to hook up with an older model of SQL Server you’ll get the next warning:
“The information supply doesn’t help a reside connection. Exploring multidimensional fashions with a reside connection requires SQL Server Evaluation Providers 2012 SP1 CU4 or later.”
- Ensure “Join reside” possibility is chosen then click on OK
- SSAS cubes and views can be found to pick out within the Navigator window
- Click on “Journey Works” dice and click on OK
Observe: Keep in mind that you should have an Enterprise or Enterprise Intelligence version of SQL Server Evaluation Providers in any other case you’ll get the next error:
“Errors associated to characteristic availability and configuration: The ‘Tabular View’ characteristic shouldn’t be included within the ’64 Bit Commonplace’ version of Evaluation Providers.”
- You need to see a listing of “Measure Teams” and “Dimensions” within the “Fields” pane
- Broaden “Web Gross sales” measure group
- Tick “Web Gross sales Quantity” measure
- Broaden “Gross sales Territory” dimension
- Tick “Gross sales Territory” hierarchy
Observe: It’s actually superior that SSAS Hierarchies are supported in Energy BI Desktop (when utilizing Join reside state of affairs) so it’s best to see that drill down is enabled in your column chart.
- Click on the “Drill down” to allow drill down motion
- Now if you happen to click on on every column on the column chart, it’ll drill right down to the subsequent ranges
Observe: “Dad or mum Youngster” hierarchies are additionally supported. To see the way it works:
- Add a Matrix into the report
- Broaden “Resellers Orders” measure group
- Choose “Resellers Orders Rely” measure
- Broaden “Worker” dimension
- Choose “Staff”
- Take away “Worker Stage 06” from “Rows”
Now that we created a quite simple report we are able to publish it to Energy BI Service. I’d wish to remind you once more that you should set up and configure “On-premises Information Gateway” on a machine in your community first. Then you should “Managing SSAS Multidimensional Information Supply from Energy BI Service”. You additionally have to have a Energy BI Professional Account.
- Save the present Energy BI Desktop report
- Click on “Publish” button kind ribbon
- Click on “Check in”
- Enter your Energy BI Service account
- You’ll immediate to pick out your Microsoft account sort instantly after getting into your Energy BI account
Observe: You will need to click on “Work or Faculty account”.
In any other case you’ll get “Sorry, you don’t appear to have entry to Energy BI.” error.
- Enter your password then click on “Check in”
- You could have efficiently printed your report into Energy BI Service
To verify your report is printed appropriately login to your Energy BI Service account. You need to have the ability to open the report.
For those who can’t see the report and see the next message on high of the report then
- you didn’t configure your Enterprise Gateway appropriately
- you didn’t grant entry proper to the person
- otherwise you printed the reviews to a improper Energy BI Account
“Report couldn’t entry the info supply since you should not have entry to your information supply by way of an Enterprise Gateway”
Examine if the Enterprise Gateway configured appropriately
- Login to your Energy BI Service Account
- Click on “Handle Gateways” kind Settings menu
- Your person account needs to be gateway administrator
- You need to see the gateway you created earlier than. Take a look at right here to see find out how to use On-premises Information Gateway.
- Click on “Check all connections”
- You need to see the standing as On-line
- In case your connection to the gateway fails you’ll see a message like “The gateway is both offline or couldn’t be reached”
- On this case you should open On-premises Information Gateway and reconfigure it
Examine if the person has entry to the info supply
- Login to your Energy BI Service Account
- Click on “Handle Gateways” kind Settings menu
- Your person account needs to be gateway administrator
- You need to see the gateway you created earlier than. Take a look at right here to see find out how to use On-premises Information Gateway.
- Broaden the gateway to see the underlying information sources
- Click on a desired SSAS Multidimensional information supply. Take a look at this to see find out how to handle an SSAS Multidimensional information supply.
- Click on “Customers” tab
- Enter the customers’ e-mail addresses then click on Add (you possibly can add a couple of customers on the identical time)
- Now open the report from Energy BI Service and it ought to work
