Forum Discussion

ffontana's avatar
ffontana
Frequent Visitor
5 years ago

Run report with dynamically filter on sysdate

Hi, I need to run one report everyday and i need that the day is changed automatically. I have used a service to access on my database (SAP4/Hana), and I used an URL on ODATA .   Source = OData.F...
Need Help
ffontana's avatar
ffontana
Frequent Visitor
5 years ago

Hi Robert ,

thank you for your support.

So i must modify my URL using JSON.Document instead of ODATA feed , is it right?

 

OData.Feed("https://sapxx.com:8xxx/sap/opu/odata/sap/service/EventiSet?$filter=(Iwerks eq '1100' and IdateStart eq datetime'" & DateTimeZone.ToText(Date.AddDays(Today,-1) , "yyyy-MM-dd") & "T00:00:00' and IdateEnd eq datetime'" & DateTimeZone.ToText(Today, "yyyy-MM-dd") & "T23:59:59')", null, [Implementation="2.0"]),

 

I need to pass in my URL the variable TODAY with the value is changed automatically every day.

So how could i do it?

I would like update the set of data , using a gateway , because i need every day to plublic the report , with refreshed data of the day.

 

Please give me a solution for this, now if i try to use gateway, Power Bi give me an error connected to dynamic variable used.

 

Many thanks.