Logo
Unify Integrations
Logo
Microsoft PowerBI

Microsoft PowerBI

Logo

3 mins READ

Power BI is a business analytics tool by Microsoft that enables users to visualize data and share insights across an organization. It connects to multiple data sources and transforms raw data into interactive dashboards and reports.

Integrating your application with Microsoft Power BI optimizes data visualization and analytics, facilitating efficient reporting and decision-making.

Authentication

Before you begin, make sure you have the following information:

  • Connection Name: Select a descriptive name for your connection, like "MyAppPowerBIIntegration". This helps in easily identifying the connection within your application or integration settings.

  • Authentication Type: Microsoft Power BI supports OAuth authentication for integrations. 

OAuth Based Authentication

  • Login into the Microsoft Azure Portal by clicking here.

  • In the search Bar, search for App Registration and then Click on new Registration.

  • Provide the Name and supported account types and register your app.

  • The Client ID refers to the Application(client) ID.

  • Click on "Add a credential or scope" to generate the client secret.

  • Copy and store it securely as it provides access to your Power BI account.

Thumbnail

Note

Frame 257.png
Frame 257.png

Actions

ActionsDescription
Add rowsAdds rows in Power BI
Add user to a workspaceAdds user to a specific workspace in Power BI
Create datasetCreates a new dataset in Power BI
Create workspaceCreates a new workspace in Power BI
Download reportDownloads a report from Power BI
Execute queryExecutes query in Power BI
Get dataset detailsGets dataset details from Power BI
Get metadata of a tableGets metadata of a table in Power BI
Get report detailsGets report details from Power BI
Get rowsGets rows of a table in Power BI
List datasetsLists datasets from Power BI
List tablesLists tables in Power BI
Search reportSearches a report
Update reportUpdates a report in Power BI
Update workspace userUpdates workspace user in Power BI