Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a report which is built on a Direct Query to an SQL server. This brings in real time data for today only. I have the following filter in place:
I then publish the report and set a browser to refresh the page every minute to get a real time dashboard on a screen.
The problem is at midnight it doesn't start to report on the next day, it says on the day it was last published. To get around this I have to go into Desktop and refresh the data and republish the report. This is not something that I should have to do surly.
Is there a way to make it so it reports on the current day only and automatically ticks over to the current/next day at midnight?
Solved! Go to Solution.
Hi @Anonymous,
Could you have tried with the SQL Statement to filter your data before you get your data?
Based on my test, you could use the GETDATE ( ) function (https://docs.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql?view=sql-server-2017#b-getting-the-current-system-date) to get today's data.
Regards,
Daniel He
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi Daniel,
Thanks for the help. I've not tried this yet but it looks like it could work. I will let you know when I have tried it.
I have made changes to the Advnaced SQL import as you suggested and added the other filters etc as you can't mix and match it seems. It's running fine for now but we will see if it updates correctly tomorrow. Fingers crossed.
Hi @Anonymous,
Could you have tried with the SQL Statement to filter your data before you get your data?
Based on my test, you could use the GETDATE ( ) function (https://docs.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql?view=sql-server-2017#b-getting-the-current-system-date) to get today's data.
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.