After publishing to workspace I get a "dynamic data sources can't be refreshed" error

[Anonymous]

Love for some input on this error, I cannot go any lower in my analysis and the MS documentation for this error doesn't apply to my scenario, to the best of my knowledge.

File that replicates the error at it's most simplest: https://drive.google.com/file/d/1yHrty3HbUwFj3CaX6h-jmUZ3zUhq1iE1/view?usp=sharing 

I've isolated the problem in the abovefile, but basically I can't seem to use the Web.Contents function inside a custom function. I've isolated the problem and demonstrated it with both parameters and strings in the attached file (if you upload it to your personal workspace, you get the following error when trying to refresh the dataset file: 

https://imgur.com/Yx1fvk3

This is the simplest version of the code that keeps failing (write the below then invoke with url string https://www.abs.gov.au/statistics/labour/employment-and-unemployment/labour-force-australia/mar-2021...😞

let
    Source = (Parameter1 as any) => let
    Source = Excel.Workbook(Web.Contents(Parameter1), null, true),
    Data1 = Source{[Name="A85255136K_Data"]}[Data]
in
    Data1
in
    Source

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Try the code and parameter1 like this:

let
    Source = Excel.Workbook(Web.Contents("https://xxx/xxx/labour/employment-and-unemployment/labour-force-australia/",[RelativePath=Parameter1]), null, true),
    A85255136K_Data1 = Source{[Name="A85255136K_Data"]}[Data],
    #"Kept First Rows" = Table.FirstN(A85255136K_Data1,1)
in
    #"Kept First Rows"

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.