Friday, July 24, 2015

Power Bi Desktop Release Today

You can download the much hyped up Power BI Desktop (formerly Power BI Designer). There are many blogs about the new features, but I am going to mention one here that I have been waiting for.

It involves connecting to the Analysis Service database as a connection and not an import all the tables into the Power BI file.

Once Power BI Desktop is Open…

image Click on Get Data…

image  then highlight SQL Server Analysis Services Database

Click Connect…

image 

Now, you have a new option

- Explore the Tabular model by using a live connection

You no longer have to use the option to retrieve the data into the Power BI file.

Once you click OK after entering the instance name…

image

You now can Navigate to the SSAS Database and select the Model or Perspective to connect to. Once selected, click OK

image

Now, you can start building the visualization like PowerView connected to a tabular database.

image

No comments:

Post a Comment