Forum Discussion
mbc
6 years agoFrequent Visitor
How to send subscribed reports with updated date selections?
Hi, Im looking for a solution to make our reports select the latest month, whenever it is automatically sent using subscription. We are using Azure SQL database and so the data updates according...
- Anonymous6 years ago
mbc
The workaround is set the default slicer to the updated date, please refer to this blog:https://littledumbo.com/2019/05/23/how-to-set-default-value-for-slicers-in-power-bi-using-dax/
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mbc
6 years agoFrequent Visitor
This is a great reply!
Yeah, its a challange with Direct Query limitations.
I'll go forward with the solution u describe with my collegue tomorrow.
U'll hear from me again,
Thx again.
Anonymous
6 years agoNot applicable
hi mbc - Sure, give it a go and let me know if it works out. Thanks!