cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Back again with another edition of 'How we use Dropbox', so find out how Emma uses to-do lists to get it all done here!

Dropbox API Support & Feedback

Find help with the Dropbox API from other developers.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Power Query Data Source Dropbox (Excel File Saved in Dropbox), How to connect?

Power Query Data Source Dropbox (Excel File Saved in Dropbox), How to connect?

mielkew
New member | Level 2

Hi Dropbox Support Team,

 

Is there any way I can use the excel file stored in my Dropbox folder as a data source for my power query? How this can be done? I saw some discussion online about it, but does not provide a step-by-step process how it can be done.

Any help or assistance in this matter is highly appreciated.

 

Thanks,

Mielkew

1 Reply 1

Re: Power Query Data Source Dropbox (Excel File Saved in Dropbox), How to connect?

Greg-DB
Dropboxer

I can't offer any insight on the Excel side of things, but you can use the Dropbox API to programmatically access file data in a connected account, using /2/files/download:

 

https://www.dropbox.com/developers/documentation/http/documentation#files-download

 

(There are also corresponding methods in the SDKs, if you're using one, which we do reccomend.)

 

Regarding the Excel part of this, perhaps someone else on the forum has some experience with that. Otherwise, you may want to try an Office/Excel forum.

Poll
We love to learn from the educators who use Dropbox. Whether you teach kids, teens, adults or a combination of all three, we want to know what apps and integrations you use with Dropbox to help with teaching. Which of the ones below is your favorite, or most used tool?
Who's talking

Top contributors to this post

  • User avatar
    Greg-DB Dropboxer
What do Dropbox user levels mean?
Need more support?