Power BI Desktop Can't Connect to Data in Dropbox

[muhammad susanto]

hi all..

i have data excel in dropbox.com , i want to connect them using Power BI Desktop but not connected show message :
"Detail : The download data is HTML , which is'n......
The URL maybe wrong.....not have provide the right credendtial to server.."

how to fix this problem
this sample link to access

https://www.dropbox.com/s/6w7v08zy7lj1763/xxxx yyyy 1212.xlsx

thank id advance to help me out.
susant

 

[GooberTron]

Hi susant,

In the advanced editor modify it to be:

Source = Excel.Workbook(Web.Contents("https://www.dropbox.com/s/6w7v08zy7lj1763/xxxx yyyy 1212.xlsx?dl=1"), null, true)

 

[muhammad susanto]

hi GooberTron, i can't see the table..? please, how to easy step

 

[GooberTron]

Open Power BI
Do "Get data" > Blank query
Open the Advanced Editor in Power Query and paste in / make sure it shows the following:

let
    Source = Excel.Workbook(Web.Contents("https://www.dropbox.com/s/6w7v08zy7lj1763/xxxx yyyy 1212.xlsx?dl=1"), null, true)
in
    Source

It may prompt you about authentication for the data source, I just used anonymous as it's a public web link.

 

[muhammad susanto]

hi GooberTron, wow...working great!!!
thank you very much.