Dropbox API v2, as API1 has been turned off

masplin,

I get same error as yours when enter credential for Dropbox in Power BI Service, the workaround is to republish PBIX file each time you have refresh.

Meanwhile, I would recommend you vote up the following idea that add Dropbox connector in Power BI.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6663925-dropbox

In addition, do mask sensitive data such as access token before uploading your pictures and posting your replies.

Regards,
Lydia

If you're running with on premise gateway, how would you add this data source?

In V1 it's easy since it reads as a web url source. Anyone has luck trying this out?

The code above works fine except you have to put the exact tokena nd path in the source line.  i managed to get it to read the table.

I'm just hoping to be able to use some sub queries ot make it look neater and easier to manage

your code (below) works only on PBI Desktop.

once it is published, it gets credential error on PBI Service.

is there any workaround to make it work and refresh on PBI Service?

let
Source = Excel.Workbook(Web.Contents("https://content.dropboxapi.com/2/files/download", [Headers=[Authorization="Bearer mytoken", #"Dropbox-API-Arg"="{""path"": ""/myfolder/myfile.xlsx""}"]]), null, true)

in
#"Source"

You are exactly right. I just went to the service to change our refresh schedule and noticed the error. I am looking into it now and will report back if I find a solution. Sorry about that!

Hmm wierd as works fine for me on the srvice. I updated al lmy sources in desktop, republished and it just worked? did even touch the credentials.

yeah, I know. I suspect there is an issue in my Brazilian server from PBI Service, as i have another dropbox project that I know works on US east (Virginia) but does not work here.

where is your PBI Service data being stored? USA? other place?

which version are you using?

I am under:

Version 13.0.2597.188
Activity ID nah
TimeTue Oct 03 2017 17:34:25 GMT-0300 (Hora oficial do Brasil)
Your data is stored inBrazil South (Sao Paulo State)

where do you find that info? I'm in UK so guess some european host

at the upper right corner, click "?" button, and go to About Power BI.

north europe (ireland)

My info:

Version13.0.2597.188

Activity ID......
TimeTue Oct 03 2017 15:54:20 GMT-0500 (Central Daylight Time)
Your data is stored inNorth Central US (Illinois)

Error screenshots from service:

Sorry I have no idea as not really a techy. 

seems  i have misled everyone. I rechecked and doesnt seem I had applied the source changes in my model. i just did republished and now have the same error as you guys. That's a little frustrating to say the least. 

Mike

ok that isnt going to happen as we auto refresh every night!!!

I've voted thanks for your help

definitely it is not an option do republish every time...

I also voted for this idea, but it is under review since 2014. Sadly, that means it is never gonna happen.

why? because end users are supposed to buy onedrive for business from Microsoft, that´s why.

which is garbagge. as is sharepoint. Replication is slow and unreliable. Shocking products and vety dangerous as you thikn you have correct daya and it just isnt

Hi masplin,

I have been trying to connect to Dropbox as well, so I have seen all your comments and different strategies, which at the end didn't work with Dropbox API v2 & Power BI Service... So sad.

Did you have any other update? I already voted & posted at the Dropbox "idea".

Plan B: Installing dropbox in our windows server and link as a local file...

I have a support ticket opened for more than 7 months, and nothing improves.

every month some engineer ask me to get tracer logs using fiddler, and they say they cannot replicate the issue with my original pbix that I sent to them. I refuse to close this ticket, because I know they don´t want to make it easier for onedrive rivals.