PowerBI Integration with L Squared Hub
Using PowerBI Widget App Authentication
You can either use L Squared’s App or can create your own app in your active directory and integrate it with L Squared Hub.
Using L Squared’s PowerBI App
If you want to use L Squared’s App, please contact your L Squared Customer Success Team coordinator, or write to support@lsquared.com and they will set this up for your server.
Note: Your organization’s PowerBI administrator required to grant consent to the L Squared’s App to access your organization’s PowerBI information.
Using Your Own PowerBI App
To create a PowerBI app for integration with L Squared Hub, please follow these steps to create the app in your Active Directory.
Note: Your organization’s PowerBI administrator required to grant the API permissions to your app. Create Your Own PowerBI App
1. Login to your Azure portal.
2. Go to “Azure Active Directory”.
3. Go to “App Registration” and click to “New Registration”.
4. On “Register an application” page, provide a name for your app.
5. Select “Accounts in this organizational directory only” option, or choose as per your requirements.
6. For “Redirect URI”, select “Web” and enter: https://hub.lsquared.com/api/v1/auth/powerbi
or
https://<your sub domain>.lsquared.com/api/v1/auth/powerbi
If you are not sure, you can connect your L Squared Customer Success Team coordinator and they will provide you the URL.
7. Click on “Register” button.
8. Once the application is saved, Azure will show “Overview” of the new app.
9. Note the “Application (client) ID”. This will be required while creating the PowerBI widget in L Squared Hub.
10. Go to “API Permissions”.
11. Click on “Add a permission” button
12. Click on Microsoft Graph.
13. Click on "Power BI service"
14. In “Delegated Permissions”, select following APIs:
a. App.Read.All
b. Dashboard.Read.All
c. Dataset.Read.All
d. Gateway.Read.All
e. Report.Read.All
f. Workspace.Read.All
15. Click on “Grant admin consent for <Your App Name> ”. If you are not a PowerBI admin, you will have to connect with your organization’s PowerBI admin and get it granted.
16. Go to “Certificates and secrets” and click on “New client secret”
17. Provide a name for the client secret and select “Never” for it’s expiry. Then click on “Add” button.
18. The new client secret will get added to your app.
19. Note the secret “Value”. This will be required while creating the PowerBI widget in L Squared Hub.
Note: This secret value will not get visible again so this should be copied at this step only.
If you are already having a PowerBI app that you want to use for L Squared Hub integration, please confirm that the Redirect URI, API Permission, and Grant Admin Consent are done as per the above steps.
Once the app is created, please follow these steps to create a PowerBI widget in L Squared Hub: