Forum Discussion
OneDrive does not update data
I try to use OneDrive together with dashboard, but updaqting of the data doeas not work. Could you figur out what is the problem?
regrads
Hi James1965,
Based on my test, We can connect to multiple .CSV files exist in OneDrive for Business in Desktop, we need to creat each web query to connect to separate .CSV file. After publish the report to service, we can go to the dataset settings enter credential for data source and set schedule refresh.
Best Regards,
Qiuyun Yu
9 Replies
Hi James1965,
Do you use OneDrive or OneDrive for Business? Only the latter supports auto-refresh.
In addition, assuming you use Excel files, please confirm that your Excel files on OneDrive for Business are explicitly refreshed by you. Power BI can only pull the data from an already refreshed workbook, it will not refresh the Excel files themselves.
Hi, Could you tell me whether we need to set up a scheduled refresh for Power BI online to refresh data from One Drive for Business or does it happen automatically?
Hi,
Thank you. I use OneDrive for Business, but data are many csv-files in a folder. More csv-files are moved in over times.
Can you check which refresh error you get, when you select the dataset in PowerBI.com --> Datasets?
Do you use the import from folder in your query to append the CSV files into a single table?
I think that this functionality isn't supported by the service - only a direct download of CSV/Excel files from OneDrive for Business.
I use onedrive personal (.xlsm file).
My data is changed by a macro (Locally). Sent to the cloud onedrive person each hour
