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…
Click on Get Data…
then highlight SQL Server Analysis Services Database
Click Connect…
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…
You now can Navigate to the SSAS Database and select the Model or Perspective to connect to. Once selected, click OK
Now, you can start building the visualization like PowerView connected to a tabular database.
