Forum Discussion
PowerBi - Source Excel File @ One Drive - Returning zeros on every other Scheduled refresh issue
Hello PBI Community, Hope someone can help me with the issue I'm about to describe. Setup: - PowerBI Desktp Pulling Excel File from OneDrive - Excel file at OneDrive has daily, hour, minute, manu...
Hi pointer_pbi ,
How do you connect to Excel files in onedrive?Excel?web?
If use excel connetor, onedrive refresh is different as you thought. It only trigger when that source file(pbix) updated. It should be the reason you mentioned why it not refresh when data source(csv files) updated.
In this case, you need to configure a gateway and refresh with the basic scheduled refresh.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.