Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI Rest API authentication failed in Service

Hi there folks,   To get actual automated insights in our dedicated Power BI environment (workspaces, apps, datasets, reports and users) we are trying to build a dataset which fetches this informat...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    For anyone stumbling into this topic. Making a data gateway for both connections and skipping the test connection solved the issue. It now refreshes without any issues in the server.

     

     

     

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi Anonymous ,
I usually use a custom connector for this task, but looking the query that generates the token, you have a dynamic data source in there. Check out Chris' blog you've mentioned and create a relative path for the tenant ID.
Although it doesn't explain the error-message, it might be worth a try.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ImkeF,

     

    Thanks for your reply. Unfortunately, the error message is not on linked to the generate token query but to the query that fetches the data from https://api.powerbi.com . I have tried anyway to replace the tenantId with a relative path in the Web.Contents function but this did not make any difference.

     

    You mention using a custom connector. Before I start looking into that, why would this (theoretically) solve my problem?


    Regards,

     

    Remo