Forum Discussion
PowerBi - Source Excel File @ One Drive - Returning zeros on every other Scheduled refresh issue
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.
Hello V-lianl-msft ,
I got connected linking the file copying the web address (File > Info > Copy path and delete the ..web... on the address) of the file into PowerBI Desktop, this way it works great on Desktop Version with no 0's showing, everything happens when is online.
I followed the steps to get connected the way described above and have organization credentials logged to connect to the OneDrive excel file via Web credentials and per same documentation stated that no Gateway is needed if connected with Organizational credentials.
What I've done is:
1. I've made a copy of the file to another folder and copied/renamed the original pbix with this new source.
2. Scheduled automated task to run every hour at the 50'th minute to copy the excel file at OneDrive original folder to the New folder (where no one has acces to).
3. Scheduled the dataset scheduled refresh to every 00 min, I'm testing this possible solution during the weekend and next week.
Cross my fingers this work although is not the best or most efficient solution. But my guts say that this happens when the live(original) file is being saved when it shows 0's.