CODEWITHSUNDEEP
office365powerbionedrive
James Neil
James Neil

Reputation: 33

OneDrive Office 365 - Power Query

I use Power Query extensively to pull data from files in folders, stored on drives. My company is moving away from shared drives in favour of storing documents on OneDrive as part of their Office 365 package.

This will clearly wreck the M-Coded filepaths in my queries. But, how does Power Query interact with Office 365/OneDrive?

Is it even possible to recreate what I was doing if all my source files have been moved to this location?

Upvotes: 1

Views: 169

Answers (1)

ibarrau
ibarrau

Reputation: 388

There is no problem you can change the source step of edit queries from local excel file to onedrive. I have a post in my blog on how to get this data, but I have to warn is in spanish. https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive

Hope it helps, Regards

Upvotes: 1

Related Questions