Power Automate Refresh faile

Question

Team - I need help...This is my situationI am using Mquery in my PBI DAX and I tried to use Power Automate to refresh PBI dataset based on a condition.. Automate flow in the refresh step does not get executed..&nbsp;This is the error I am getting. Any pointers please.&nbsp;&nbsp;This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed.&nbsp;dhivyabharathi&nbsp;

amirabedh · Answer

Can you share your M code ?I recommend following this&nbsp;https://tengkuma.vercel.app/blog/posts/conquering-urls-with-relativepath-and-query-in-power-bi&nbsp;

krishnakumar_ra · Answer

AmiraBedh&nbsp;et&nbsp;&nbsp;&nbsp; // Access SharePoint site and specify API version&nbsp;&nbsp;&nbsp; Source = SharePoint.Contents("https://sharepoint.com/sites/AdvancedAnalyticsCenterofExcellence2/", [ApiVersion = 15]),&nbsp;&nbsp;&nbsp;&nbsp; // Navigate through the folder structure to the target directory&nbsp;&nbsp;&nbsp; #"SCORE Data Upload" = Source{[Name="SCORE Data Upload"]}[Content],&nbsp;&nbsp;&nbsp; SCORE = #"SCORE Data Upload"{[Name="SCORE"]}[Content],&nbsp;&nbsp;&nbsp;&nbsp; // Function to process each file&nbsp;&nbsp;&nbsp; ProcessFile = (file as record) =&gt;&nbsp;

krishnakumar_ra · Answer

Help please&nbsp;

Forum Discussion

Power Automate Refresh faile

3 Replies

Related content

Refresh Power BI Dataset using Power Automate

Automated refreshes

Automate PQ Refresh?

Dataset refresh via Power Automate Flow - clarifications

Refresh PBI with Power Automate