Dropbox API v2, as API1 has been turned off

[masplin]

Hi

I have been linking severla single files stored on dropbox using API! whiuch seems to have bene disabled last night. I think there are a lot of us in the same boat.  Can someone say what the equivalent code is for API2?  I tried change the path to "https://api.dropboxapi.com/2/files/auto/DataModel/SourceFiles/" but that just errors.  My files are just sitting in a normal dropbox folder as can't us an App folder as can't be shared. 

The code i was using was

let
    Source = Excel.Workbook(Web.Contents(DropboxSourcePath & "Inputs.xlsx" & Token), null, true),
    Centre_Table = Source{[Item="Centre",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Centre_Table,{{"Opening Date", type date}})
in
    #"Changed Type"

Where  Dropboxsourcepath

let
    Source = "https://api-content.dropbox.com/1/files/auto/DataModel/SourceFiles/"
in
    Source

and token

let
    Source = "?access_token=xxxxxxxxxxxxxxxxxxxxxxx"
in
    Source

Grateful any advice as whole company reporting has collapsed

Thanks

Mike

[Anonymous]

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.

[masplin]

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

[aarola]

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...

[Anonymous]

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.

[Anonymous]

Hi all, has anyone succeeded with finding a solution to this one? I've been trying your examples without any success. Thanks

[masplin]

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

I've voted thanks for your help