Hi all,
I created a Power Automate to extract usage metrics data from 9 workspaces and dump the dataset in CSV files. The flow looks like below. The workspace names are stored in an array variable. Then, "Apply to each" is used to loop through the array. It calls Power BI - Run a query against a dataset function to output the dataset of "Usage Metrics Report" in CSV format and save it in SharePoint for each workspace.
The error I get is "404 Not Found" for all 9 workspaces, but I'm 100% sure that Usage Metrics Report exists in all of them. Also, if I run the flow with static values - hard coded the workspace name and Usage Metrics Report dataset, it runs successfully.
Did I miss any component in the flow?
