Prerequisites for connecting to PowerBI
1. Open access to PowerBI endpoints required to get data and collect images from PowerBI
To integrate with PowerBI, particularly for getting data, you must deploy Metric Insights' Remote Data Collector (RDC). The RDC must be installed on a Windows machine that can access your PowerBI environment. The following endpoints must be opened:
- app.powerbi.com, port 443
- *.windows.net, port 443
- powerbi.microsoft.com, port 443
- dc.services.visualstudio.com, port 443
- login.microsoftonline.com, port 443
- *.office.com, port 443
2. Install the Remote Data Collector
For steps on how to install the RDC, please see the Configure a Remote Data Collector article.
3. .NET and SQL OLE-DB adapter must be installed on the RDC host machine
1. RDC requires .NET FrameWork v4.5 or higher
2. Download and install SQL_AS_OLE-DB adapter (https://download.microsoft.com/download/8/7/2/872BCECA-C849-4B40-8EBE-21D48CDF1456/ENU/x64/SQL_AS_OLEDB.msi)
4. Create powerbi-poc.conf if it does not already exist
- In C:\Program Files (x86)\Metric Insights\Insightd\plugins (or where the RDC is installed) create a powerbi-poc.conf configuration file
- Enter the following parameters with correct values:
pathToOleDbExe=C:\Program Files (x86)\Metric Insights\Insightd\plugins\oledb\OLE DB Connector.exe
5. Register an Azure application representing Metric Insights to embed PowerBI content
To create and register an app, please follow the instructions in this Microsoft article: https://docs.microsoft.com/en-us/power-bi/developer/register-app
This creates 'trust' between PowerBI and Metric Insights in order to embed PowerBI content.
Please make sure to "Grant Permissions" while configuring the App in Azure Portal.
6. Create a PowerBI connection profile in Metric Insights
Now that you've completed the prerequisities, you are now ready to create a connection profile in Metric Insights! Please follow the steps in this article to complete the integration: http://help.metricinsights.com/m/Connecting_to_Data_Sources/l/700173-establish-connectivity-to-microsoft-powerbi