SSAS Connector and Power BI Preview

Key things about SSAS connector and Power BI Preview

• Only SQL Server Analysis Services Tabular models are supported for Power BI Preview
• The connector has to continue running and the computer where it is installed has to remain on.
• When you use the SSAS connector, your data remains on-premises.  The reports you create based on that data are saved in the cloud.
• Q&A natural language querying is not currently available for SSAS on-premises tabular data.  Only cloud-based datasets are supported for Q&A.

Pre-requisites SSAS connector and Power BI Preview

• NET Framework 4.5.1 or later must be installed on the computer.
• Installing the Power BI Analysis Services Connector and the Data Management Gateway on the same computer is not supported. If you already have the Data Management Gateway installed, uninstall it before installing the Power BI Analysis Services Connector, or install the Connector on different computer.
• The Analysis Services server is domain joined.
• The Analysis Services connector & Analysis Services server are installed on computers in the same domain.
• If you use a .onmicrosoft.com email address, you'll need to sync your Active Directory to Azure Active Directory using Azure Active Directory Sync (DirSync).

Technorati Tags: Power BI Preview,SSAS

Power BI Dashboard on Power BI Preview Site

I recently built a dashboard using the Google Analytics data of my blog using the Power BI designer Preview.

The Designer generated a .pbix file and now I wanted to publish it to my Power BI Preview site.

Log on to the Power BI Site.

Created a Dashboard folder named “CodeSpot” my blog name.

Click on “Get Data” and select “Power BI Designer File” and click “Connect”

Select the .pbix file from the File System and Click Connect and the file will be uploaded to the Power BI Preview Site.

And Here is the uploaded .pbix file.

Technorati Tags: Power BI,Google Analytics

Power BI Designer Preview - Google Analytics Connector

Today I tried using the Google Analytics Connector released recently as part of Power BI Designer Preview to get some insights about my blog. It was relatively easy to get going.

Step 1:Open Power BI Designer Preview and click Get Data

Step 2:Select Google Analytics from the Get Data screen

Step 3:Select the site name for getting the Analytics data

Step 4:List of subject areas, measures and dimensions

Step 5:Select the subject areas and measures from the site

Step 6:Final Output