You can find your Power BI application credentials by visiting your Microsoft Azure Portal.You’ll need the following information to set up your Power BI app with Paragon Connect:
Under Integrations > Connected Integrations > Power BI > App Configuration > Configure, fill out your credentials from the end of Step 1 in their respective sections:
Client ID: Found under Essentials > Application (client) ID on your Microsoft Azure Portal app page.
Client Secret: Found under Manage > Certificates & secrets on your Microsoft Azure Portal app page.
Permissions: Select the scopes you’ve requested for your application. For a list of recommended scopes, please view this integration within your Paragon dashboard. View dashboard.
Press the purple “Save Changes” button to save your credentials.
Note: You should only add the scopes you’ve requested in your application page to Paragon.
Once your users have connected their Power BI account, you can use the Paragon SDK to access the Power BI API on behalf of connected users.See the Power BI REST API documentation for their full API reference.Any Power BI API endpoints can be accessed with the Paragon SDK as shown in this example:
Copy
Ask AI
// You can find your project ID in the Overview tab of any Integration// Authenticate the userparagon.authenticate(<ProjectId>, <UserToken>);// List Datasetsawait paragon.request("powerbi", "myorg/datasets", { method: "GET"});// List Reports by IDawait paragon.request("powerbi", "myorg/reports/{reportId}", { method: "GET"});// Query Accounts by number of employeesawait paragon.request("microsoftDynamics", "/accounts?$filter=Microsoft.Dynamics.CRM.Between(PropertyName='numberofemployees',PropertyValues=["5","2000"])” method: "GET"});
Once your Power BI account is connected, you use the Power BI Request step to access any of Power BI’s API endpoints without the authentication piece.When creating or updating records in Power BI, you can reference data from previous steps by typing {{ to invoke the variable menu.