In one in every of my earlier posts I defined learn how to use Energy BI on prime of your SSAS Multidimensional utilizing Information Import Situation. You may also discover definitive rationalization about “Managing Evaluation Providers Multidimensional Mannequin” right here. On this submit I present you learn how to join stay 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 Guardian Baby

On this submit you’ll study:

• Find out how to join stay from Energy BI Desktop to SSAS Multidimensional
• Creating experiences utilizing SSAS objects like hierarchies
• Publishing your experiences from Energy BI Desktop to Energy BI Service

To have the ability to efficiently create and publish your experiences utilizing Energy BI Desktop on prime 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 do not forget 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

Word: As I discussed earlier it is advisable have SQL Server 2012 Evaluation Providers SP1 CU4 or later. So when you’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 stay connection. Exploring multidimensional fashions with a stay connection requires SQL Server Evaluation Providers 2012 SP1 CU4 or later.”

• Be sure that “Join stay” choice is chosen then click on OK

• SSAS cubes and views can be found to pick within the Navigator window

• Click on “Journey Works” dice and click on OK

Word: Do not forget that it is advisable 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.”

• It is best to see a listing of “Measure Teams” and “Dimensions” within the “Fields” pane

• Develop “Web Gross sales” measure group
• Tick “Web Gross sales Quantity” measure
• Develop “Gross sales Territory” dimension
• Tick “Gross sales Territory” hierarchy

Word: It’s actually superior that SSAS Hierarchies are supported in Energy BI Desktop (when utilizing Join stay situation) so you must see that drill down is enabled in your column chart.

• Click on the “Drill down” to allow drill down motion
• Now when you click on on every column on the column chart, it can drill right down to the subsequent ranges

Word: “Guardian Baby” hierarchies are additionally supported. To see the way it works:

• • • • Add a Matrix into the report
      • Develop “Resellers Orders” measure group
      • Choose “Resellers Orders Depend” measure
      • Develop “Worker” dimension
      • Choose “Staff”
      • Take away “Worker Degree 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 it is advisable set up and configure “On-premises Information Gateway” on a machine in your community first. Then it is advisable “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 your Microsoft account sort instantly after getting into your Energy BI account

Word: 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 will have efficiently printed your report into Energy BI Service

To verify your report is printed appropriately login to your Energy BI Service account. It is best to have the ability to open the report.

When you can not see the report and see the next message on prime of the report then

• you didn’t configure your Enterprise Gateway appropriately
• you didn’t grant entry proper to the consumer
• otherwise you printed the experiences to a mistaken Energy BI Account

“Report couldn’t entry the info supply since you don’t have entry to your information supply by way of an Enterprise Gateway”

Test if the Enterprise Gateway configured appropriately

• Login to your Energy BI Service Account
• Click on “Handle Gateways” kind Settings menu
• Your consumer account ought to be gateway administrator
• It is best to see the gateway you created earlier than. Take a look at right here to see learn how to use On-premises Information Gateway.
• Click on “Check all connections”
• It is best 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 it is advisable open On-premises Information Gateway and reconfigure it

Test if the consumer has entry to the info supply

• Login to your Energy BI Service Account
• Click on “Handle Gateways” kind Settings menu

• Your consumer account ought to be gateway administrator
• It is best to see the gateway you created earlier than. Take a look at right here to see learn how to use On-premises Information Gateway.
• Develop the gateway to see the underlying information sources
• Click on a desired SSAS Multidimensional information supply. Take a look at this to see learn how to handle an SSAS Multidimensional information supply.
• Click on “Customers” tab
• Enter the customers’ e mail addresses then click on Add (you’ll be able to add multiple customers on the similar time)

• Now open the report from Energy BI Service and it ought to work