Power BI

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 uses the Power BI REST API which provides programmatic access to dashboard resources such as datasets, tables, and rows in Power BI.

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:

• Learn more about setting up Power BI by visiting Microsoft's Power BI documentation.
• Set up an Active Directory application using Azure portal.
• Create an Azure Active Directory tenant.
• Register a Power BI client app in Azure Active Directory.
• Log into Power BI.

Part of setting up Power BI requires Azure Admin Rights.

Prerequisites 

• The Datameer user is part of the relevant Power BI subscription.
• The Datameer user can provide the name of Azure Active Directory (Tenant) and the Client ID (Application ID) of the related app needed for authentication and authorization to Power BI.

• Activate the Azure application for Datameer using the following link in your web browser and adding your specific credentials found in the Microsoft Azure portal:
  
  https://login.microsoftonline.com/TENANT_ID/oauth2/authorize?client_id=CLIENT_ID&redirect_uri=REDIRECT_URI&response_type=code&prompt=PERMISSION#
  
          - 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 to a Power BI service: 

1. 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.
     
   
2. From drop-down list, select Power BI as the connection type. Click Next.
   
3. Enter the:
   Client ID: After making sure you registered the Datameer 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). 
   
   Tenant: The Tenant name, which is the Active Directory name, can be found by logging into the Azure portal and searching under Azure Active Directory > Domain Names. Follow these instructions if you need to create another Azure Active delivery tenant.
   
   Username/Password: The username is the user's Power BI credentials before the @ symbol. 
   
   The connection usage can only be set as Export . 
   
   If any error messages are given after this step, contact the Azure administrator. 
4. Click Next and then save the connector.

Configuring Power BI for Export Jobs

See Exporting to Power BI.

Help

Finding the Application ID

1. Open https://portal.azure.com/ 
2. Navigate to Azure Active Directory and open App registration.
3. Click on the App name.
4. Find the Application ID under Essentials.

Finding the Tenant ID

1. Open https://portal.azure.com/ 
2. Click the question  button in the top menu bar.
3. Click “Show diagnostics" and a JSON file opens.
4. Search for the section labeled "Tenants".
5. Find the Tenant ID.

Finding the Redirect URL

1. Open https://portal.azure.com/ 
2. Navigate to Azure Active Directory and open App registration.
3. Click on the App name.
4. Find the Redirect URL by clicking on “Redirect URIs". (Example: https://login.live.com/oauth20_desktop.srf)