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
olik,
In this case, you can use schedule refresh instead of Onedrive refresh option.
Regards,
Lydia
I know, that's the workaround/hack I've been using - but that doesn't answer the question...
olik,
This is by design. you can view more details in the following official articles.
https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive
https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Regards,
LydiaIt seems very wrong and hacky that a Microsoft OneDrive source has to be imported into Microsoft Power BI using the generic "web link" way. How can this be by design, and why can't you offer native OneDrive support in your application? Your articles talk about saving a Power BI file onto OneDrive, they don't answer that question.
I'm just exploring Power BI for the first time (because my company might move their entire infrastructure over from Tableau) and I was hoping that we might see some better synergies given all our data is stored on OneDrive - but Power BI seems to connect to it like any other file anywhere on the internet...?
olik,
Please check the discussion in the following similar thread.
http://community.powerbi.com/t5/Integrations-with-Files-and/OneDrive-Excel-to-OneDrive-pbix-to-Power-BI-Service/td-p/105194/highlight/false/page/2
Regards,
Lydia