Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I need help updating my power bi page when i update my excel. My excel is stored in a folder on my desktop and i am using power bi desktop. I need to update my excel weekly and have it reflected over in my power bi. Right now when i update my excel and click the refresh data button which is located in the 3 dots next to the table name, the new data does not sync over from excel to power bi. Is there another way to do this and be able to update my power bi when i add more data to my excel sheet
Solved! Go to Solution.
1) If you are trying to refresh from PBI Desktop you refresh by clicking on the "Refresh" icon in the Home ribbon:
2) If you want to automate the PBI refresh process, you can do so by installing a Gateway on our machine (it has to be on for the refresh to work) and setting the refresh schedule in the PBI service for your uploaded report
Check:
On premises Gateways
3) Alternatively you can host your Excel file in Onedrive for Business and the refresh will be automatic (no gateway needed). This works for reports uploaded to the service (not Desktop)
Excel Data source on Onedrive
Microsoft doc on Onedrive for business and Excel
Proud to be a Super User!
Paul on Linkedin.
1) If you are trying to refresh from PBI Desktop you refresh by clicking on the "Refresh" icon in the Home ribbon:
2) If you want to automate the PBI refresh process, you can do so by installing a Gateway on our machine (it has to be on for the refresh to work) and setting the refresh schedule in the PBI service for your uploaded report
Check:
On premises Gateways
3) Alternatively you can host your Excel file in Onedrive for Business and the refresh will be automatic (no gateway needed). This works for reports uploaded to the service (not Desktop)
Excel Data source on Onedrive
Microsoft doc on Onedrive for business and Excel
Proud to be a Super User!
Paul on Linkedin.
Without seeing exactly what you're doing when you say you "update my excel", it's hard to suggest a solution, if your Excel file is in any sort of sensible structure there's no reason why a simple refresh in Desktop wouldn't work, unless you're making a new Excel file with a different name, different worksheet name etc each week, which could probably be worked around in Power Query
Hi thank you for the response. I am simply adding data into my already made columns and it is not syncing over to power bi. Is the correct way to click on the 3 dots on the table name and select refresh data?
@Jimmmythomas , refer if power automate can help
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |