Power Automate Refresh faile

[krishnakumar_Ra]

Team - I need help...
This is my situation

I 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.. This is the error I am getting. Any pointers please. 

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. 

@dhivyabharathi 

[krishnakumar_Ra]

Help please 

[AmiraBedh]

Can you share your M code ?

I recommend following this https://tengkuma.vercel.app/blog/posts/conquering-urls-with-relativepath-and-query-in-power-bi

[krishnakumar_Ra]

@AmiraBedh 

et
    // Access SharePoint site and specify API version
    Source = SharePoint.Contents("https://sharepoint.com/sites/AdvancedAnalyticsCenterofExcellence2/", [ApiVersion = 15]),

    // Navigate through the folder structure to the target directory
    #"SCORE Data Upload" = Source{[Name="SCORE Data Upload"]}[Content],
    SCORE = #"SCORE Data Upload"{[Name="SCORE"]}[Content],

    // Function to process each file
    ProcessFile = (file as record) =>