Forum Discussion
Solved
Connect to Sharepoint or OneDrive folder/CSV files using DataFlow
Hello,
Is that possible to setup a Dataflow connecttion to folder of CSV files in a MS sharepoint or onedrive ? I can do this using Desktop version of PowerBI, but is that feasible using Dataflow?
- Yes it is.
Simply put, as there currently is no UI to connect to Sharepoint / Onedrive, just use the advanced editor to retrieve the final query from Power Query inside Power BI Desktop and put the query inside a blank query inside a dataflows.
Regards,
Tim
2 Replies
- Yes it is.
Simply put, as there currently is no UI to connect to Sharepoint / Onedrive, just use the advanced editor to retrieve the final query from Power Query inside Power BI Desktop and put the query inside a blank query inside a dataflows.
Regards,
Tim Hello, since you mention that you "can do it using Desktop", how does that work for OneDrive folder? I am putting in my organisational account and I think I use correct cleaned up paths without the ending keep getting errors. Thank you for any help.
