Re: Power Automate Refresh faile

krishnakumar_Ra · ‎06-25-2024

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 · ‎06-30-2024

Help please

AmiraBedh · ‎06-25-2024

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

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

krishnakumar_Ra · ‎06-25-2024

@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) =>