SSAS Tabular Live Power BI Connection

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

4

When Power BI 2.0 released as General Availability I’ve published a post that highlights all new features in this product. One of the features was SSAS Tabular Live Power BI Connection. In this post I want to explore more what the Live connection means and what are advantages of this type of connection. Power BI Designer (Previous version of Power BI Desktop) was supporting offline connection to SSAS. The new SSAS Live connection of Power BI only works with SSAS Tabular at the moment.

Offline Connection

Previously there was only one type of connection to SQL Server Analysis Services (SSAS) from Power BI, and that was offline connection. Offline means that connection only worked to fetch data for a query or more. The result of query have to manipulated in query editor, or in the model through relationship management, to finally be ready for report.

This method of offline connection is useful when you work with non-modeled data sources, such as CSV files, Web search, excel spreadsheet… But when you have a data model, such as star schema model in your SSAS then creating another model in Power BI Designer is just an extra step which needs extra effort and adds load time.

When you use Get Data to connect Analysis Services;

6

Here is an example of Offline connection:

7

Here is where you have fetch data, and build queries:

8

as you can see in screenshot above you cannot select the whole model, you should choose a dimension, measure group, or combination of attributes and measures. Then you have to build relationship between them in Power BI model.

and Here is where you have to build relationships again:

9

Live Connection

The new Power BI Live connection for SSAS Tabular removes this barrier, it is actually works like the Power View connection to SSAS, it loads the structure and data from the model within SSAS in an instant. there is no extra loading time required for the model, except the SSAS processing time itself. As a result Power BI Desktop is getting one step further to be a product that can be used in enterprise environments.

Here is where you connect to SSAS Tabular through Live connection:

25

You can select whole model in this mode;

26

and Here is all your model metadata loaded:

4

You will also mention that in this mode you won’t see Data and Relationship tabs in the left hand pane. you just see report tab.

5

Good News

The good news for you that have your data model in SSAS Tabular is that you don’t need to re-invent the wheel and built it again in Power BI relationship management.

Bad News

The bad news is that if you have your model in SSAS Multi-Dimensional you still have to wait. Because this feature is only supporting SSAS Tabular at the moment. My assumption is that same type of connection will be available for SSAS multi-dimensional in next few months updates of Power BI.

 

 

SSAS Tabular On-Premises Connection

As a side note here I would like to mention that If you have built your SSAS Tabular on premises, you can connect to it through Power BI Analysis Services Connector.

Simply download the connector from here:

http://www.microsoft.com/en-us/download/details.aspx?id=45333

2

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

4 thoughts on “SSAS Tabular Live Power BI Connection

Leave a Reply

Your email address will not be published. Required fields are marked *