Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities making it easier for business users to create reports and dashboards.
Datameer X uses the Power BI REST API which provides programmatic access to dashboard resources such as datasets, tables, and rows in Power BI.
The Power BI plug-in comes standard as of Datameer X v6.3. It allows users to export workbooks in Datameer X by creating a connection to Power BI's cloud offering in Azure. Users with the Power BI desktop version for Windows should instead use an integration link.
Power BI Resources
The following resources are necessary to complete Power BI setup. Go through them and complete any necessary steps before proceeding with setup on Datameer X
- The REDIRECT URI must be html encoded. Example: "https://login.live.com/oauth20_desktop.srf" is written as "https%3A%2F%2Flogin.live.com%2Foauth20_desktop.srf" - The PERMISSION configuration setting can be set as consent for a normal user or admin_consent for an admin user giving access to all users in the Active Directory.
Configuring Power BI as a Connection
Create a connection in Datameer X to a Power BI service:
Select the + (Plus) button at the top left of the File Browser tab and select Connection, or right-click on a folder, select Create New then select Connection.
From drop-down list, select Power BI as the connection type. Click Next.
Enter the: Client ID: After making sure you registered the Datameer X app with Power BI, find the Client ID, which is used by the app to identify itself. It is called the Application ID in the Azure portal. In the provided link the sign in for the Microsoft Azure subscription has changed to https://portal.azure.com/.Ensure the Native App (Client App) is used rather than the Server Side Web-App (Web App).