PowerBI to Dropbox Integration

[michaelhowes25]

Hi PBI community, 

I am looking for a solution whereby I can access the data that drives my PowerBI reports via Dropbox, and not via the file path I currently have set to access Dropbox on my local folder 'C://Users:micha\' (as I am currently doing).

The reason for this is so that other PowerBI users at the company can use and refresh these reports by having access to files managed on the Dropbox - they obviously have different local file directories so could not feasibly use the same path as me. 

I need a solution where the Dropbox folders can be accessed from multiple users - something that will require an API. I'm wondering if you'd have any advice or ideas on how best we might do this?

I've found some support online (https://www.thebiccountant.com/2017/06/25/import-multiple-files-dropbox-folder-powerbi-excel-via-pow...) that looks a very helpful post and I thought would help, but the code returns an error for me. 

I think there may be some added complexity here in comparison with the example above, in terms of accessing the data via Dropbox business credentials. 

Any help would be so appreciated.

thanks,

Michael

[lbendlin · Accepted solution]

Yes, the dropbox approach would only work with files/folders that are shared publicly.  Can you consider alternatives like Sharepoint?

[V-pazhen-msft · Accepted solution]

@michaelhowes25 
There is a way to connect to drop box with ODBC, see if helps:
Publish Real-Time Dropbox Data to PowerBI.com (cdata.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Yes, the dropbox approach would only work with files/folders that are shared publicly.  Can you consider alternatives like Sharepoint?

[michaelhowes25]

Hi, thanks for your response. Yes, I think Sharepoint / OneDrive Business is probably the best solution... thanks, Michael