For connecting to Power BI from DataTrust, we need a reusable Client ID and a Client Secret key is required.
Follow these steps to create the Client ID and Application secret key:
1. Application in the Power BI Developer’s portal. Navigate to https://dev.powerbi.com/apps and log in with your account credentials (using UPN account - "onmicrosoft.com").
2. Once you sign in, click next
3. Provide an Application Name and choose an application type as "Server-side web application". Provide a Home Page URL and a Redirect URL, as shown in the following image.
4. Provide "Read all" access to "datasets", "dashboards", "reports", "workspaces" as shown below:
5. Click "Register"
6. This will generate "Application ID" and Client secret keys.
7. Copy the "Application ID" and "Application Secret", you will need these to create a Power BI connection profile in DataTrust.
8. Basic read access required for reading the datasets, dashboards, reports, and workspaces in the account. Click on Register once done
9. To connect to Power BI from DataTrust, Create an Application in the Power BI Developer’s portal. This app will provide us with a reusable Client ID and a Client Secret key, using which we can generate the embed token required for the REST API.
10. This app will provide us with a reusable Client ID and a Client Secret key, using which we can generate the embed token required for the REST API.