Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
masplin
Impactful Individual
Impactful Individual

Dropbox API v2, as API1 has been turned off

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

26 REPLIES 26
Anonymous
Not applicable

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
Impactful Individual
Impactful Individual

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

Anonymous
Not applicable

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
Not applicable

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

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

 

I've voted thanks for your help

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors