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.
What's the problem you are encountering? If a data source for a Power BI semantic model is located on SharePoint/OneDrive and that data source changes then allegedly the semantic model refresh is initiated "within the hour". If you don't want to wait for that you can use a Power Automate trigger "When file is modified" to initiate the refresh request. Make sure to debounce it though to avoid 429 errors.
First, a user uploads an excel file in onedrive. Then, a refresh on the Power BI report should automatically trigger on workspace. After that, I need to make Power BI automatically import that file in onedrive. How can I do it?
Use the Power Automate trigger "When a file is added" rather than "When a file is modified".