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

3 comments:

  1. Incredible post! This is really nice
    table presentation on different Versions and service packs of SQL.
    I appreciated your way of presenting about SQL. Thanks for posting.Keep it.up.
    See More information about SQL Server

    ReplyDelete
  2. Thanks for the post, very useful. Would like to suggest best training on power bi visit Power BI Online Training india

    ReplyDelete
  3. Thanks for sharing the very useful info about power bi and please keep updating......
    Power BI Online Training
    Power BI Online Training bangalore

    ReplyDelete