Wednesday, July 29, 2015

Power BI connections: Personal Gateway or Analysis Services Connector

You have your Power BI account, you've  looked over the samples and created a few reports with static data from Excel and a few flat files. Now you want to make the next step and start using data from your organizations data warehouse and tabular databases.  But you've noticed that there seems to be more than one tool to make the connection.  But which tool, if any do you need? Or do you even need them at all? Earlier you created a report using data pulled from a networked SQL Server, all without installing either the Personal Gateway or the Analysis Services Connector. So, which is it?  The Power BI Personal Gateway, the Analysis Services Connector, both or neither?

Personal Gateway vs. Analysis Services Connector

A good way to think of the Personal Gateway is that it allows your reports, on your Power BI portal to connect to the organization's data warehouses and other supported databases and systems. The Analysis Services Connector, on the other hand, connects a single SSAS tabular server to all the Power BI users (who have access permission, naturally).

Personal Gateway
The most natural location to install your Personal Gateway is on your computer. Key things to consider:
  • It cannot be installed on the same computer as the Analysis Services Connector
  • The Personal Gateway runs on a computer you control. it is for your reports alone
  • It must be up and running to support a refresh. So the computer where it is installed must be up and running.
  • It's used for on-premise data sources, except tabular servers
  • Installation: Runs as a service if installed by an administrator. Otherwise, it must be started like an application. So try to get your administrator to set it up for you.
  • If you want to refresh your data from on-premise data sources, you need to install the Personal Gateway
  • It's only supported on 64 bit Windows operating systems (including Windows 10)
  • MS Power BI Support:Power BI Personal Gateway

Analysis Services Connector

The most elegant approach for installing the Analysis Services Connector is to install it on the same server running the SSAS tabular server.Key things to consider:
  • It cannot be installed on the same computer as the Personal Gateway
  • The Connector is mapped to a single Analysis Services server. So for every tabular server you want to use, you need to install and configure an Analysis Services Connector
  • It can run on any domain computer, but ideally it can be installed on the tabular server
  • Only supports SSAS tabular models at this time
  • MS Power BI Support: 

No comments: