Search code examples
powerbipowerquerym

Dynamic query (Current date) via web services in Power Bi

In my project we are consuming the company's data via Web Service REST. Today we don't do the query dynamically by passing the start date and end date parameters via string.

enter image description here

My goal is for the end date to update dynamically. I've already created a query that takes the current date but I can't put it in the parameter without generating an error in the query.

enter image description here

This is the error message I get when I put the column value in the parameter:

enter image description here

I'm pretty sure I'm getting the syntax wrong. Anyone who can help me, I really appreciate it. I would like to point out that the date format for the API call to work is DD/MM/YYYY.

Solution

  • Can you try using

    PutYourOtherTableNameHere[Hoje_Coluna]{0}

    instead of

    [Hoje_Coluna]

    ?

    To see if that will work, put this in right before your query, then click on the step and see what it returns.

    x = PutYourOtherTableNameHere[Hoje_Coluna]{0},