Forum Discussion

michaelhowes25's avatar
michaelhowes25
Regular Visitor
4 years ago
Solved

PowerBI to Dropbox Integration

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-powerquery-at-once/) 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
General Comment
Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

    • michaelhowes25's avatar
      michaelhowes25
      Regular Visitor
      4 years ago

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