Forum Discussion
Power BI automation
I have solved the problem.
First, I upload the empty raw account file in OneDrive.
Then, I import the OneDrive folder in Power BI Desktop and selected "Combine & Transform Data".In Power Query, I filter out the empty raw account file and enable fuzzy matching and set threshold = 0.8 when merging queries as new. Join: Left Outer (all from first, matches the second).
I create the table visual and create the efficiency measure for the card visual.
I have save and publish the report.
Power Automate:
Recurrence -> Refresh a dataset in power BI -> Delay: 15 seconds -> Run a query against a dataset ->Parse JSON -> Create CSV table -> Create file in OneDrive
Once the user uploads the raw account file, power automate will activate automatically.
When the power automate finishes successfully, Power BI report in workspace automatically refreshes and shows the results in table visual and the efficiency value in card visual.
After that, it also create a file in OneDrive and display the result from the table visual.
First, I upload the empty raw account file in OneDrive.
Then, I import the OneDrive folder in Power BI Desktop and selected "Combine & Transform Data".
In Power Query, I filter out the empty raw account file and enable fuzzy matching and set threshold = 0.8 when merging queries as new. Join: Left Outer (all from first, matches the second).
I create the table visual and create the efficiency measure for the card visual.
I have save and publish the report.
Power Automate:
Recurrence -> Refresh a dataset in power BI -> Delay: 15 seconds -> Run a query against a dataset ->Parse JSON -> Create CSV table -> Create file in OneDrive
Once the user uploads the raw account file, power automate will activate automatically.
When the power automate finishes successfully, Power BI report in workspace automatically refreshes and shows the results in table visual and the efficiency value in card visual.
After that, it also create a file in OneDrive and display the result from the table visual.
There is no guarantee that the refresh completes successfully in under 15 seconds. Make that delay much longer, or change the flow to include refresh status polling.