Forum Discussion
Get csv file from OneDrive and auto-update
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
That thread raises the same issue, but doesn't provide a solution or even an answer as to why I can't natively link a OneDrive source in Power BI desktop...
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
Hi
how do you link to a OneDrive folder that has multiple CSV files stored into powerbi desktop, Create the reports, Publish and then get it to do a scheduled refresh?
