Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |