Failed to save modifications to the server

[fabiojoa]

Hello Everyone!

I created a query looking for an online spreadsheet that is updated daily. As the date is one of the parameters of the file name, I made an expression to generate dynamism in the file.

I create a blank query called DataAtual with a expression:

= "https://www.ecdc.europa.eu/sites/default/files/documents/COVID-19-geographic-disbtribution-worldwide-" & Date.ToText(#date(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()), Date.Day(DateTime.LocalNow())), "yyyy-MM-dd") & ".xls"

And then I changed the original query called CSV_4_COMS using the name of the blank query that I created.

= Excel.Workbook(Web.Contents(DataAtual), null, true)

When I click Close and Apply, I get the following message:

Has anyone gone through something similar and been successful in the solution?

[dax · Accepted solution]

Hi @fabiojoa , 

If possible, could you please trsnaslate the error information to English? Then I will help you more correctly.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[dax · Accepted solution]

Hi @fabiojoa , 

If possible, could you please trsnaslate the error information to English? Then I will help you more correctly.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[fabiojoa]

[dax · Accepted solution]

Hi @fabiojoa , 

Please check "n/a" value in your dataset , did this prompt when you use date function? If so, I think this might be related to date function can't recognize "n/a"? You could try to replace this to null or other date which could used in function.

Best Regards,
Zoe Zhi

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