Forum Discussion
Power Automate Refresh faile
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...
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
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) =>