Forum Discussion
Get csv file from OneDrive and auto-update
Hi all,
I'm trying to build a report in Power BI desktop, based on a csv file on OneDrive for Business.
I used "Web" as a data source (following this: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links) and all worked fine, but when publishing the dataset doesn't get recognised as a OneDrive source so I don't get the auto-update and OneDrive-specific options.
I also noticed that I get the "OneDrive - Business" option when creating a new dataset online, but I can't find that in Power BI Desktop.
So, how correctly create my report? Why can't I see the "OneDrive - Business" option in Power BI Desktop?
Thanks!
olik,
You are able to link onedrive data source in Power BI Desktop. After you create report in Power BI Desktop and upload PBIX file to Power BI Service, you are able to enable OneDrive refresh option for your dataset in Service.
However, in this case, only when you make changes(e.g create new measure, edit report) in PBIX file, the changes will update in report within one hour in Power BI Service. When you change data in the csv data source, the change will not get updated in Power BI Service report based on the onedrive refresh schedule(One hour). To bring the change of csv file to Power BI Service, you can use shedule refresh or refresh now in Power BI Service.
Regards,
Lydia
10 Replies
olik,
It seems that you want to use "OneDrive Refresh" for your dataset so that when data changes in the csv file, the dataset and report will get updated within one hour.
If that is the case, you would need to directly connect to the CSV file in Power BI Service using "OneDrive - Business" option , and create report in Power BI Service, this way, onedrive refresh option will appear.
Regards,
Lydia
