Connect Dropbox or One Drive to Power BI desktop

[shrutiiyer]

Hey everyone! I've an excel file stores in dropbox and I need to connect it to Power BI desktop to get started with creating visualizations. Is there a way to connect DB files to Power BI? 

[Icey]

@shrutiiyer ,

For Dropbox, please check if these posts are helpful: 

Import multiple files from Dropbox folder into PowerBI and Excel (via PowerQuery) at once;

Data source hosted on Dropbox.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shrutiiyer]

Thanks so much for replying @Icey I saw those two links last week and faced a few issues that I mentioned on the comment above. I came across a lot of people who are stuck in the same step as me and nobody found a solution yet. 

[amitchandak]

@shrutiiyer , For one drive, refer this. There is a small change needed in URL

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

For DropBox

https://community.powerbi.com/t5/Desktop/Data-source-hosted-on-Dropbox/td-p/47882

https://www.thebiccountant.com/2017/06/25/import-multiple-files-dropbox-folder-powerbi-excel-via-pow...

[shrutiiyer]

Thanks Amit! Facing a few errors following the YT video turorial. Specifically after the invoke action - An error occurred in the ‘’ query. DataSource.Error: Web.Contents failed to get contents from 'https://api.dropboxapi.com/2/files/list_folder' (400): Bad Request Details: DataSourceKind=Web DataSourcePath=https://api.dropboxapi.com/2/files/list_folder Url=https://api.dropboxapi.com/2/files/list_folder