Power BI: Difference between revisions
mention a different power BI integration scenario |
Marek Rodak (talk | contribs) No edit summary |
||
| Line 11: | Line 11: | ||
An example of the integration is available on [https://github.com/Resconet/JSBridge/tree/master/Integration/PowerBi GitHub]. | An example of the integration is available on [https://github.com/Resconet/JSBridge/tree/master/Integration/PowerBi GitHub]. | ||
[[File:Power BI dashboard.png|600px]] | [[File:Power BI dashboard.png|alt=Displaying Power BI dashboard in the iframe overview|600px]] | ||
This section serves as a quick overview of the steps required to integrate your Power BI properly with Resco. | This section serves as a quick overview of the steps required to integrate your Power BI properly with Resco. | ||
| Line 24: | Line 24: | ||
# Verify that the appropriate permissions are available. | # Verify that the appropriate permissions are available. | ||
[[File:Power bi service permissions.png|600px]] | [[File:Power bi service permissions.png|alt=Displaying Power BI dashboard in the iframe: Check Power BI service permissions in your https://portal.azure.com|600px]] | ||
=== Get OAuth settings === | === Get OAuth settings === | ||
| Line 31: | Line 31: | ||
# Copy the value of the parameter '''Application (client) ID'''. | # Copy the value of the parameter '''Application (client) ID'''. | ||
[[File:Power bi copy client id.png|600px]] | [[File:Power bi copy client id.png|alt=Displaying Power BI dashboard in the iframe: Get OAuth settings: Power BI copy client id|600px]] | ||
=== Get client secrets === | === Get client secrets === | ||
| Line 38: | Line 38: | ||
# Create a new client secret or use an existing one. | # Create a new client secret or use an existing one. | ||
[[File:Power bi client secret.png|600px]] | [[File:Power bi client secret.png|alt=Displaying Power BI dashboard in the iframe: Power BI client secret|600px]] | ||
=== Configure authentication === | === Configure authentication === | ||
| Line 45: | Line 45: | ||
# Configure the authentication options as needed. | # Configure the authentication options as needed. | ||
[[File:Power bi authentication.png|600px]] | [[File:Power bi authentication.png|alt=Displaying Power BI dashboard in the iframe: Power BI authentication|600px]] | ||
=== Settings for workspace and and report / dashboards === | === Settings for workspace and and report / dashboards === | ||
| Line 69: | Line 69: | ||
In the code downloaded from the [https://github.com/Resconet/JSBridge/tree/master/Integration/PowerBi Power BI integration by Resco], you can find the method where we try to retrieve the access token using settings for OAuth OAuth_Settings. | In the code downloaded from the [https://github.com/Resconet/JSBridge/tree/master/Integration/PowerBi Power BI integration by Resco], you can find the method where we try to retrieve the access token using settings for OAuth OAuth_Settings. | ||
[[File:Power | [[File:Power BI name of the account.png|alt=Displaying Power BI dashboard in the iframe: method to retrieve the access token using settings for OAuth OAuth_Settings|600px]] | ||
The settings are stored in the associated name in the secure storage. If any settings exist for the passed name, we will use them, the [https://github.com/Resconet/JSBridge/blob/master/Integration/PowerBi/PowerBiOAuthSettings.js OAuth_Settings] are ignored. | The settings are stored in the associated name in the secure storage. If any settings exist for the passed name, we will use them, the [https://github.com/Resconet/JSBridge/blob/master/Integration/PowerBi/PowerBiOAuthSettings.js OAuth_Settings] are ignored. | ||
Revision as of 09:58, 21 November 2023
Power BI is a business analytics service by Microsoft. It can be used along with the Resco platform. This wiki offers two examples of integration between Resco and Power BI:
- Display Power BI dashboards within Resco Mobile CRM (described in this article)
- Visualize data from Resco questionnaires in Power BI (see deep dive)
Getting started
Resco Mobile CRM and other Resco mobile apps can display Power BI dashboards in an iframe.
An example of the integration is available on GitHub.
This section serves as a quick overview of the steps required to integrate your Power BI properly with Resco.
For any questions, please contact our technical support.
Check permissions
Check the permissions for the Power BI Service in your https://portal.azure.com/.
- Go to App registrations and open your app.
- Select Manage > API permissions from the menu.
- Verify that the appropriate permissions are available.
Get OAuth settings
- Select Overview from the menu.
- Copy the value of the parameter Application (client) ID.
Get client secrets
- Select Manage > Certificates & secrets from the menu.
- Create a new client secret or use an existing one.
Configure authentication
- Select Manage > Authentication from the menu.
- Configure the authentication options as needed.
Settings for workspace and and report / dashboards
To get the settings for workspace and report / dashboards, follow the instructions in Microsoft documentation.
Advanced
If you have any problem with the previous step, use this nuget package in the PowerShell console.
Start the PowerShell console as an Administrator and run the following commands. (Microsoft docs)
- Start PowerShell as an Admin.
- Install-Module -Name MicrosoftPowerBIMgmt
- Connect-PowerBIServiceAccount.
- Get-PowerBIWorkspace
- Get-PowerBIworkspace -name "{report_name}" | Get-PowerBIReport
- Get-PowerBIReport -Id 5364xxxx-xxxx-xxxx-xxxx-xxxxf1e7df89
- Get access token: Get-PowerBIAccessToken -AsString
Important
In the code downloaded from the Power BI integration by Resco, you can find the method where we try to retrieve the access token using settings for OAuth OAuth_Settings.
The settings are stored in the associated name in the secure storage. If any settings exist for the passed name, we will use them, the OAuth_Settings are ignored.
In case you change those settings and want to apply these changes, you should delete all data in the setup, or pass a different name for the new settings.