Help on files retreival

[mkathi0405]

Hi I would like to migrate a folder of files from onedrive to powerbi. The folder of files will be increasing as time passes by. What would be the best way to deal with it. Thanks 

[v-cazheng-msft]

Hi @mkathi0405 

Do you want to connect to a folder on OneDrive? You can enter the link of  your OneDrive for Business folder like the following to the SharePoint Folder connector. Then Transform data in Power Query and filter the ‘Folder Path’ column to the folder you want to connect. For more details, you can refer Power BI> Get Data from OneDrive for Business(Folder as a source.

The form of the link: https://mydomain-my.sharepoint.com/personal/user_mydomain.com

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau · Accepted solution]

Hi. I think you might be confused or the requirement is not quite clear. Power Bi is not a storage. You can't save your data in Power Bi. You can read it from OneDrive and create analytics about them.

You can't migrate folder or files from Onedrive to Power Bi. You can only read that data.

I hope that make sense