Forum Discussion
Data source hosted on Dropbox
Can you please look at my URL below and see if I did it correctly because it still says "authentication failed". What is the proper format of the filepath?
ankitpatira wrote:sshweky URL should be as below and you choose anonymous method as you already have api token specified in URL
https://api-content.dropbox.com/1/files/auto/{FILE PATH}?access_token={YOURAPITOKEN}
sshweky URL should be as below and you choose anonymous method as you already have api token specified in URL
https://api-content.dropbox.com/1/files/auto/{FILE PATH}?access_token={YOURAPITOKEN}
Can you please look at my URL below and see if I did it correctly because it still says "authentication failed". What is the proper format of the filepath?
ankitpatira wrote:sshweky URL should be as below and you choose anonymous method as you already have api token specified in URL
https://api-content.dropbox.com/1/files/auto/{FILE PATH}?access_token={YOURAPITOKEN}
It works for me when I get a link from dropbox via vile explorer and when I paste the link I change "?dl=0" for "?dl=1". Then I can use the url in Power Query getting data from web.
"https://www.dropbox.com/s/je1pd9qmopp5t_____________rec2015.xlsx?dl=0" change it to "https://www.dropbox.com/s/je1pd9qmopp5t_____________rec2015.xlsx?dl=01"
I cold not make it work with a folder and haven't tried with the Power BI service. Hope it helps.
Have you or anyone else had an issue when the dropbox explorer link got changed automatically?
I have an excel file which I have linked using your method in various PBI reports, like this "https://www.dropbox.com/s/je1pd9qmopp5t_____________rec2015.xlsx?dl=01".
And now I am back from my holiday and all the PBI reports are not refreshing because the link has changed. The 'file' is still in the same dropbox folder and has the same file name. I asked my colleagues, but nobody changed the file location or such.
Just wondering if there is some better way to link the dropbox file in the future inorder to avoid opening all the desktop files> editing the link> and publishing it again. Chaotic!
