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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Impactful Individual
Impactful Individual

Dropbox API v2, as API1 has been turned off



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


    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}})
    #"Changed Type"

Where  Dropboxsourcepath


    Source = ""

and token


    Source = "?access_token=xxxxxxxxxxxxxxxxxxxxxxx"

Grateful any advice as whole company reporting has collapsed




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.

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

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.

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors