Connect to Sharepoint or OneDrive folder/CSV files using DataFlow

[mohammed_essam]

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?

[JanBuzek]

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.

[TomMartens · Accepted solution]

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