Forum Discussion

fabiojoa's avatar
fabiojoa
Icon for Helper I rankHelper I
6 years ago
Solved

Failed to save modifications to the server

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?

 

Need Help
  • dax's avatar
    dax
    6 years ago

    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's avatar
    dax
    6 years ago

    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.

3 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        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.