Unable to refresh dataset in pbi service for azure devops datasource

[Anonymous]

Whenever I try to refresh a dataset in service via MS PowerAutomate, I get error - You can't schedule refresh for this dataset because the following data sources currently don't support refresh. My source is simply through Azure DevOps which I suppose is supported in PBI service.

ex:

source = OData.Feed(https://org-name.analytics.visualstudio.com/projectname/$filter=.....)

The exact query I am using is:

source = OData.Feed("https://{org name}.analytics.visualstudio.com/{project name}/_odata/WorkItemSnapshot?$filter=WorkItemType eq %27User Story%27 and DateValue ge 2021-01-14 and Release eq %271.0%27&$select=DateValue, WorkItemId, State, StoryPoints")

When I refresh this dataset in PBI service, which was captured and saved in PBI desktop file, I get dynamic dataset not supported error. 

Any information on how to schedule automatic refresh in service for this sort of data source is highly appreciated.

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

There are several blog posts on how to work around this problem.

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI

Dynamic Web.Contents() and Power BI Refresh Errors

Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failure...

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the reply. I do got it resolved myself by using VSTS.Contents method and tweaking my pbix file a little bit. It did not seem to work in first attempt but after modifying pbix file did resolve my problem.

Thanks again.