Easiest and fastest way to get ANY data from OneDrive for Business into Power BI

I have shown you on a previous video how to get data from OneDrive to Power BI , but there is a better and faster way to do it now. Let me show you how!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[danielkogan]

Hi Ruth, great video as usual. Maybe you want to add the following tip. You can change the m code to Sharepoint.Files -> Sharepoint.Contents. That way you don't have to filter, which can be really slow if you have millions of files on your OneDrive. By using Sharepoint.Contents you get the actuall folder structure and you can drill down to the folder you want to load.

[alan.makes]

Simple and straight to the point, not like all the other fluff and nothing happens, THANK YOU!!

[dannyhometown]

Love this one. I used SharePoint List and folders a lot, but never knew it could also get data from OneDrive. Great Tips, Ruth. Thank you.

[mattmiller]

Ruth, this is such a fantastic tip. I've been wondering how to do that. Many thanks. Stay safe and healthy.

[denisw]

Brilliant tip, thanks! I spent several hours trying to get files from folder.

[rodneypearman]

I’ve been learning a lot from your great little video’s, especially this one. Obvious to many, but if like me you had not noticed - a breath of fresh air. Keep up the good work!!!

[DrSMA]

Thanks for such great video but is there any way to connect regular OneDrive folder to power bi?!

Thanks

[AndreasHenschel-cy]

Okay that sounds nice and all. But I have a question.

I have a Folder on onedrive where for each Employee we have an Excel file with the vacation days. When I now add a new Excel file for a new employee does this type of connection also take the new file when I refresh data in PowerBi?

[ngokadonald]

Hi Ruth, lovely video as usual, is there any way to replicate this for OneDrive personal?

[herovalmoria]

Hi Ruth, it seems that this step does not work with shared folder from other person. Is there any way to access the data from a shared folder contents?. Please advise.

[soymb]

Hi Ruth, Thanks for this! I thought that this was imposible. This is really good! Please more videos about tips and tricks of Power Bi connections to other programs/apps of MS Office environment.

[TusharMeshram]

This is exactly what i was looking for

[osielgutierrez]

Hello thanks for sharing, I have done the exercise but for example I connect to a folder that has 85 files in excel with extensions "xls, " xlsx "and" xlsm ", when I update the model in power bi, it is too long (30 Minutes to put a time) the time it takes to read the information, do you know what could be happening? Thank you, excellent explanation.

[luisgrados]

but if i dont have a sharepoint account, is ti possible to conect pbi to onedrive?

[revit_danielmaya]

Muchas gracias Ruth por tu valioso aporte. Eres un Sol.

[stephenbrincat]

Hi Ruth, if I'm not mistaken this is only for One Drive for buinesss

[kahhengyeong]

Nice! Oh that reminds me of another thing.
How to import data from Dynamics 365.
If I'm not wrong, it's still not available in my region (Asia) but would be good to have a head start. Thanks! :)

[NaraMeerammaTrust]

I think still it has got one issue. As long as the developer uses one drive for business and use that one as data source and he continues in the project, it is fine. If he leaves the project then how will that data source will get refreshed? Don't you think it is a practical problem unless he does the KT to the other people in the team and they modify the source file. Can you please think of this situation and let us know the possible best solutions. I always prefer to keep the files on the Network drives rather One Drive . Look forward for your response. Thank you Ruth

[wanderleihuttel]

Unfortunately it only works with onedrive business, for the personal or family it doesn't work.

[revit_danielmaya]

Dice que el acceso está denegado. Me puedes ayudar?