Subscription for BI Reports

[nschreck91]

Hello, I have a BI subscription currently set up to be sent out weekly. But when it sends out, the screen shot within the body of the email shows no data and has old dates from back in decemeber instead of the most recent data. Even after a refresh is performed. 
any ideas?

[v-diye-msft · Accepted solution]

Hi @nschreck91 

If I understand correctly you subscribed yourself to have Power BI email you a screenshot of your report. Per the documentation:

Email subscriptions are sent with the report's default filter and slicer states. Any changes to the defaults that you make after subscribing don't show up in the email.

So I would assume that you had old date selected as default filters (the filters set in Power BI Desktop when the publisher published the report) and that means that today will never show. To confirm this click the reset filter button in the toolbar at the top of the report and see what it shows. Then talk to the report publisher and have them change the date filter to be an advanced filter of “on or after XXX date”

[Anand24]

Hi @nschreck91 ,

The best way to check email subscriptions is by refreshing the dataset and then hitting a 'run now' subscription and send the subscription to yourself.

If you are getting correct data while performing this, then everythin is correct but there is probably old data in dataset when subscription is triggered weekly.

If you see unexpected behavior of different data in report and subsctiption, then you can raise support ticket here.

Most of the data mismatch issues with subscriptions are due to dataset refreshes only.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[nschreck91]

Hello @Anand24 ,

The data has already been refreshed and showing correctly on the report itsself. The screenshot sent in the subscription email however, is not showing accurate date. its blank and show Decemeber in the date filter instead of August

[Anand24]

@nschreck91 ,

This moreover seems to be a bug if you are getting proper data in report but not in email at the same time.

You should create a support ticket.

[GilbertQ]

Hi there

Could I ask you when you pinned the tiles too the dashboard were they pinned from the report page where you were looking at data in December?

When pinning to the dashboard it will remember the filter state at the time it was pinned to the dashboard. This could be why it is always showing December.

Try pin a new item, then click on the "Run now" and see if it shows the updated data?