Refresh Show Error : Web Content Failed To Get Contents..

[muhammad susanto]

hi all...
in the several days my dashboard is as well but today since i refresh my excel sheet into dropbox, show message '
batam
Web.Contents failed to get contents from 'https://www.dropbox.com/s/dl/6f28pq3sw2k18sm/KPKNL BATAM 2022.xlsx' (404): Not Found'
i'm using Excel 2021, power bi desktop

how to fix the problem?
my excel file ever renaming but today is back to original file name
why still error, can't refreshing data.

maybe someone give me a solution.
thank in advance
susant

 

[smozgur]

hi suat, thank you it's usefully for me.

Glad to hear it helps, Muhammad.

Thanks for the feedback.

 

[muhammad susanto]

hi suat, i found new problem, why now not connected.. here my complete code
the fact, the file can be download

let
    Source = Excel.Workbook(Web.Contents("https://www.dropbox.com/scl/fi/tnsdg5fgtzm688t9g2uki/KPKNL-BUKITTINGGI-2022..xlsx?dl=1"), null, true)
in
    Source

show message "DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server"

 

[smozgur]

hi suat, i found new problem, why now not connected.. here my complete code
the fact, the file can be download

let
    Source = Excel.Workbook(Web.Contents("https://www.dropbox.com/scl/fi/tnsdg5fgtzm688t9g2uki/KPKNL-BUKITTINGGI-2022..xlsx?dl=1"), null, true)
in
    Source

show message "DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server"

Since this one is a protected source or somehow it requires your permission to access (you might have selected to share with "Only people invited" instead of "Anyone"), Dropbox will return an HTML page with the proper response code to ask for permission/code/password etc.

You need to set it to be "Anyone who has the link" to make it work.