Forum Discussion

mkathi0405's avatar
mkathi0405
Frequent Visitor
5 years ago
Solved

Help on files retreival

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 

Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    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

2 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    5 years ago

    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

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.