Forum Discussion

UNICODE's avatar
UNICODE
Helper I
10 months ago
Solved

Help with Odata Api call Refresh status returning Dynamic Datasources, which cannot be refreshed

Hello,  I am trying to build a query that returns the Refesh status of the Power Bi reports on the on prem Power Bi RS server.    I am trying to do this by using three api calls and Odata feed conne...
Need Help
  • v-prasare's avatar
    v-prasare
    10 months ago

    Hi UNICODE,

    The main issue usually happens when Power BI Report Server doesn’t allow dynamic URLs during refresh. Instead of building URLs on the fly, the best approach is to connect once to the top-level OData endpoint and then navigate through the tables to get what you need. For example, you can go into the PowerBIReports table, expand the  CacheRefreshPlans, and then expand the History column to view recent refresh details.

    If you do need to use  Web.Contents, make sure to use the RelativePath option and wrap it with  Json.Document() so that the data returns as a proper table. Also, make sure to check for any permission issues conflicts between AD groups and Row-Level Security can also cause unexpected refresh problems.

     

     

    Thanks,

    Prashanth

v-prasare's avatar
v-prasare
Community Support
10 months ago

Hi UNICODE,

The main issue usually happens when Power BI Report Server doesn’t allow dynamic URLs during refresh. Instead of building URLs on the fly, the best approach is to connect once to the top-level OData endpoint and then navigate through the tables to get what you need. For example, you can go into the PowerBIReports table, expand the  CacheRefreshPlans, and then expand the History column to view recent refresh details.

If you do need to use  Web.Contents, make sure to use the RelativePath option and wrap it with  Json.Document() so that the data returns as a proper table. Also, make sure to check for any permission issues conflicts between AD groups and Row-Level Security can also cause unexpected refresh problems.

 

 

Thanks,

Prashanth