Forum Discussion
Helper IIISend wrong PDF subscriptions to users across all departments
Hi KR300 ,
Thanks for getting back and apologies for delayed response. I understand the challenge of manual updates, especially for non-Power BI developers. Unfortunately, Power BI subscriptions do not dynamically capture filter changes unless explicitly modified, saved, and reconfigured.
Found a similar discussion that might be helpful:
Scheduled report shows old data - Microsoft Fabric Community– Highlights a potential issue with Power BI using UTC time for scheduling, which can misalign with local time zones. A suggested workaround is adjusting filter conditions based on UTC.
For example, if your subscription runs at Mar03 8:00 PM (UTC+10), Power BI may apply filters as of Mar03 10:00 AM (UTC+0), which could impact time-based filters like “last one day.” Adjusting the filter conditions accordingly can help.
Power BI Subscription Documentation – Explains how saving changes to a subscribed report affects subscriptions.
Possible Solutions:
- Save the report after applying filters before modifying the subscription.
- Use bookmarks to retain predefined filtered views.
- Adjust filter conditions if time-based filters are misaligned due to UTC settings.
- Modify the subscription timing to ensure it runs after the dataset refresh is complete.
- Explore Power Automate for dynamic report distribution.
Since recalling or replacing sent subscription emails isn't possible, these steps can help reduce manual effort. Let us know if you need further assistance in any of these steps.
Hope this helps! If this post was useful, please consider marking it as the solution to assist other community members, and a kudos would be appreciated.
Regards,
Vinay.
Helper IIIThanks for your valuable info.
For this we need to do manula changes everyday right,. That is the concern here.
PBI developer knows but after handing this dashbaord to the team( Non - PBI developers ), they have do this process manually everyday. -- this process is painful even thought we have automatic sending options.
I did refresh of the reprot + modifief fulters + saved -- but still getting outdated subscription vial mails then my Manangers/ Leaders asking me loudly what is the wrong with this you & Mail & PBI tool....
what i am going to tell? there are so many questions here.... Really hurtful after eventhough we have all the options still doing manual things...
Community SupportHi KR300 ,
Thanks for getting back and apologies for delayed response. I understand the challenge of manual updates, especially for non-Power BI developers. Unfortunately, Power BI subscriptions do not dynamically capture filter changes unless explicitly modified, saved, and reconfigured.
Found a similar discussion that might be helpful:
Scheduled report shows old data - Microsoft Fabric Community– Highlights a potential issue with Power BI using UTC time for scheduling, which can misalign with local time zones. A suggested workaround is adjusting filter conditions based on UTC.
For example, if your subscription runs at Mar03 8:00 PM (UTC+10), Power BI may apply filters as of Mar03 10:00 AM (UTC+0), which could impact time-based filters like “last one day.” Adjusting the filter conditions accordingly can help.
Power BI Subscription Documentation – Explains how saving changes to a subscribed report affects subscriptions.
Possible Solutions:
- Save the report after applying filters before modifying the subscription.
- Use bookmarks to retain predefined filtered views.
- Adjust filter conditions if time-based filters are misaligned due to UTC settings.
- Modify the subscription timing to ensure it runs after the dataset refresh is complete.
- Explore Power Automate for dynamic report distribution.
Since recalling or replacing sent subscription emails isn't possible, these steps can help reduce manual effort. Let us know if you need further assistance in any of these steps.
Hope this helps! If this post was useful, please consider marking it as the solution to assist other community members, and a kudos would be appreciated.
Regards,
Vinay.
- v-veshwara-msft
Hi KR300 ,
We haven’t heard from you since our last response and wanted to check if the provided solutions met your needs. If they did, please consider accepting the solution to help others benefit. Otherwise, feel free to reach out for further assistance.
Thank you!