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
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, ffontana 

To make the date changed automatically every day in your Power BI report, using the Date.IsInCurrentDay() in the Power query or using the relative time slicer and filter in Power BI can also be a good choice to achieve this if using the URL filter is failed.

You can also follow these links:

https://docs.microsoft.com/en-us/powerquery-m/date-isincurrentday

https://docs.microsoft.com/en-us/power-bi/create-reports/slicer-filter-relative-time

 

If you still have a problem with the URL filter with Odata, I suggest you to go to open a support ticket and ask the technical support team for their opinion about this question.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031

https://powerbi.microsoft.com/en-us/support/

 

Best Regards,

Community Support Team _Robert Qin

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