real-time dashboards not working even with Live Connection

I have tried and am aware that Real-time dashboards are not available in Power BI, but an auto refresh takes of a live connection place in 10-15 minutes window.
Created a report in Power BI Desktop with a Dynamic Date filter defined in Query Editor filtering the data for Today (tried on May 5th). Published the report to Power BI Service, and pinned the report to a dashboard. The connection is live connection and the tiles are refreshed in intervals. But the issue is the refresh is not bringing Today's(May 10th) Data but the May 5th Data is only shown in the tiles. Ideally, it should bring today's data (as the filter is defined as Today in Query Editor) from a live Data Source. But the data at the time the report was published is shown. It seems when the report is published, it stores the static value(May 5th) in the Power BI Service instead of Today defined in Query Editor.