Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.