Microsoft Flow Automation using Power BI API Power BI REST APIs need help

[PierreL69]

Hello, the community

I need your help regarding the API Power BI REST that I have tried to configure but without success 😞

Objectif: I have an excel file located on my Onedrive/Sharepoint (inside my company), this file is linked to a dataflow located on a PBI Premium Workspace which itself is linked to a PBI published Application.

This published application is used by my colleagues to consults their reports/dashboards.

=> What I want to do:

When I update my file (excel) I want that my dataflow is triggered to refresh, and so all the data related to this dataflow will be refreshed in my PBI Premium Workspace and consequently on the related published PowerBI Application

To do that: I understood that I needed to register an application on Azure Active Directory and then create a custom connector in Power Automate to pilot this registered application.

but I couldn't do it, so please find below the primary error I have (I think) when I tried to test my custom connector (swagger mode - Authorization step) :

[ Base URL: api.powerbi.com/ ]

Available authorizations

Scopes are used to grant an application different levels of access to data on behalf of the end user. Each API may declare one or more scopes.

API requires the following scopes. Select which ones you want to grant to Swagger UI.

oauth2_auth (OAuth2, accessCode) Jump to definition
Authorization URL: https://login.windows.net/common/oauth2/authorize

Token URL: https://login.windows.net/common/oauth2/authorize

Flow: accessCode

client_id: XXXXXXXXXXXXXXXXXXXXXXXXX
client_secret: XXXXXXXXXXXXXXXXXXXX

The error :

AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application: 'XXXXXXXXXXXXX.

So I must be missing something, and I think it is coming from my application registration in Azure Active Directory (done by an IT guy from my company with the info I supplied to him)

My questions: when I am registering my application what needs to be input in the following fields:

• Type of application:
  • Server-side web application (I chose this one)
  • native?

• Home Page URL:
  • https://www.powerbi.com
  • URL Home page address of my PBI Premium workspace
  • address of my published PBI application (related to my PBI Premium Workspace)

• Type of application:
  • https://www.powerbi.com
  • URL Home page address of my PBI Premium workspace
  • address of my published PBI application (related to my PBI Premium Workspace)
  • Redirect URL from my custom connector? (https://global.consent.azure-apim.net/redirect)

I am little bit lost, Please could you help me?

Thanks,

Pierre.

[Anonymous]

Hello Pierre, I have the feeling that the error is related to the redirect URL when you register the app in AAD. The redirect URL for app registration shall be https://login.live.com/oauth20_desktop.srf (which to my knowledge is the default value? used for desktop app), instead of the redirect URL for your custom connector I followed the post from Ioannou last year (link here: https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33) and found it useful - hope you will find it helpful.

[PierreL69]

Thanks @Anonymous 

I have made some progress in a certain way: I was able to refresh a dataset from My personal Workspace

-> something I hadn't been able to do

using this: POST https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes

Where:

• datasetId is the ID of one dataset from "My Workspace"

But what I want to do is to refresh a dataflow from my Premium workspace using : 

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/refreshes

Where:

• groupId is the ID of the PBI Premium Workspace
• dataflowId is the ID of the dataflow from the PBI Premium Workspace

But in this case, again I have the same error :

AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application: 'xxxxxxxxxxxx'.

[PierreL69]

Does anyone have any ideas please?