Forum Discussion
DirectQuery hangs with the Today function
Hi JoHo_BI,
I can't reproduce your issue, your formula works well on my side. Can you ensure you have correctly configation the datasource?
In addition, if you can please share some detail information about your issue, it will be help for troubleshooting.
Regards,
Xiaoxin Sheng
Hi Anonymous - Thanks for your reply,
Please find a link for a small test dataset available.
In the top right, there is a "IsToday" filter, using the formula from the original post. It however does not load and still throws the error.
The datasource works perfectly, I can pull in data as you can see on the table on the left.
Still very much need help!
Hi JoHo_BI,
But it works on my side:
How many records your table contains? I think the issue may related to it. Can you share some detail content?
Regards,
Xiaoxin Sheng
Hi Anonymous,
The table I am drawing from contains approx. 400k rows before I apply the table filters. After the filters, it goes to 886 rows, but still doesn't pull through the data unfortunately.
I see your report works, however IsToday always returns false. If it were to return at least 1 true record, i'm not sure it would load.