Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Refresh failing in PBI Service - Date.ToText syntax causing error?

Hi all,   I'm fairly new to Power Query, and am having trouble with a query that refreshes fine in PBI desktop, but fails when I upload it to our workspace.   The query makes a call to a REST API...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Anonymous ,

    Try changing your format argument like this:

     

    enddate = Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd"),

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Anonymous ,

Try changing your format argument like this:

 

enddate = Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd"),

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks BA_Pete ! That seems to have sorted it