Reply
Member
Posts: 201
Registered: ‎04-14-2017

Re: Connecting to data source hosted on Dropbox

Frequent Visitor
Posts: 8
Registered: ‎02-27-2017

Re: Connecting to data source hosted on Dropbox

@ImkeF, No I don't have a gateway installed. Didn't understand why I'd need one to make a specific API call. 

 

I see now that people need to specifically list folder contents and not just go for a specific file, which is what I did. First I thought it was the api method that couldn't provide that list results of folder contents, but when I tried to just do a command line curl call it worked just fine, i.e. the list_folder method can return the list of folder contents (but just not in PowerBI Desktop for some reason..). I tried all types of header parameters in the web.contents method to make it work, but I didn't succeed. Either I'm doing it wrong or it's just not possible. But it would be really strange if certain API calls just don't work.  

 

Frequent Visitor
Posts: 4
Registered: ‎10-05-2018

Re: Connecting to data source hosted on Dropbox

Hi there,

 

Trying to follow this code to get my PowerBi to refresh using web service but cannot seem to replicate.

 

In a blank query i am putting the following, is this right?

 

let

DropboxSourcePath = "https://content.dropboxapi.com/2/files/download/",

Token = "?access_token=[Token]",

Source = Excel.Workbook(Web.Contents(DropboxSourcePath & "delivery_recieved.xls" & Token), null, true)

in

Source

 

Any help appreciated!

Frequent Visitor
Posts: 4
Registered: ‎10-05-2018

Re: Connecting to data source hosted on Dropbox

Hi there,

 

Trying to follow this code to get my PowerBi to refresh using web service but cannot seem to replicate.

 

In a blank query i am putting the following, is this right?

 

let

DropboxSourcePath = "https://content.dropboxapi.com/2/files/download/",

Token = "?access_token=[Token]",

Source = Excel.Workbook(Web.Contents(DropboxSourcePath & "delivery_recieved.xls" & Token), null, true)

in

Source

 

Any help appreciated!

Frequent Visitor
Posts: 4
Registered: ‎10-05-2018

Re: Connecting to data source hosted on Dropbox

Reposting code as last version had wrong url! Smiley Happy

 

let

DropboxSourcePath = "https://api-content.dropbox.com/1/files/auto/",

Token = "?access_token=[token]",

Source = Excel.Workbook(Web.Contents(DropboxSourcePath & "delivery_recieved.xls" & Token), null, true)

in

Source