Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Refresh Issue in Power BI Service

Hello,   I have a PBI report where in Azure Cost Management (ACM) and Web are the data sources in it. The ACM connector is configured with OAuth and Web Connector calls a Microservice API with OA...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

Can you test if connecting to the data sources in separate queries (one query connects to one data source), can they always be refreshed successfully in the service?

 

Regards,
Community Support Team _ Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

If the query has one data source then it works fine. But earlier we had these two data sources in one query only and it worked fine both in Power BI Service and Power BI Template Apps as well. Now the only difference is - they are the same data sources in one query (both ACM and Web) but Web connector is calling a Microservice API with OAuth. Earlier we used to call a Logic App's http get request in Web connector with Anonymous.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous 

    The reason is probably related to the Microservice API with OAuth authentication. From this idea (Microsoft Idea · oauth), it seems OAuth authentication is currently not supported when refreshing Web API data sources in Power BI Service. It says OAuth is enabled via custom connector. However, in custom connector doc, it says OAuth for custom connectors via gateways is currently supported only for gateway admins. Since you are using the report as a template app, custom connector is probably not a good workaround.

     

    I suggest that you can open a support ticket on https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". The engineers there may help look into the issue from backend of the service.

     

    Regards,
    Community Support Team _ Jing