Forum Discussion
Power BI Dataset not automatically refreshing.
We have an excel file that is uploaded to sharepoint that we work on together in Microsoft Teams. We want this document to automatically update to a Power BI that we use to display the data on TV's i...
Hi benchjeff
I have found previously that sometimes the OneDrive refresh goes out of sync is that causes more issues and time to try and fix than it is worth.
I would import the data and then use the scheduled refresh 8 times a day (If power BI Pro license) and have it refreshing that way?
You know, we actually decided to move away from our method and are currently working on something different. We are using Power Automate to make a dataset from our Excel file. This works and the dataset refreshes every 10 minutes.
The only problem is that every time we change data in a cell, it duplicates that row in the database. Thereby making the update process fail.