Forum Discussion

JohnSwid's avatar
JohnSwid
New Member
9 years ago

Connecting to data source hosted on Dropbox

Hello PowerBI-Ites,   Has anyone had any luck connecting to Dropbox as a data source.  Couldn't find many articles on this topic.  Here's one  article that had a solution we couldn't get to work: h...
masplin's avatar
masplin
Impactful Individual
9 years ago

In your post you put the files inside the App folder so assumed you had to do that. I'll go and try with a normal dropbox folder. and report back

masplin's avatar
masplin
Impactful Individual
9 years ago

Ok so I used your code and token I had got for the whole of my dropbox. If I put no folder path I get somethnig

 

 

However i need a folder that is several layers down  Datamodel/3rd party Bookings/WCFMC

 

If i put in anything in the folder bit it errors

 

 

An error occurred in the ‘Query1’ 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

 

Any ideas how to get it to read the contents of subfolders?

 

Thnaks

Mike