Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I'm having an issue with getting my subscriptions to send when I manually refresh the dataset from a desktop file. I've searched high and low online and cant find any resources on this topic.
When I test the subscription using the 'Run now' button, I recieve it fine so there is no issue with the mail getting caught in spam.
I have other datasets with an autofresh, which also trigger the subscription fine.
Is anyone aware of a way around this? Its not always possible to have files autorefresh so it seems like a big gap in functionality.
Thanks
Solved! Go to Solution.
I think the act of refreshing the PowerBI solution locally within the PBIX desktop version is the crux of your issue.
1. Subscriptions can be scheduled to be on refresh (the service refresh not refreshing locally then re publishing)
a. I recommend using the service scheduled refresh as opposed to doing it locally.
2. Subscriptions can be on a time schedule, to be emailed at a specific interval.
3. You can use a creative Alert to serve like a subscription, if notification only is desired.
a. Create a query in MCode to retrieve current days date. This value will not be updated unless the report model is refreshed.
b. Create DAX to compare the value created in step a is today(). DAX will always return the current day, regardless if the report model has been refreshed. Have the DAX to return the interger value of the date time when true and 0 when false.
c. Create a KPI visual leveraging the DAX created in b. I would move this to a hidden tab within the report so that the consumer wont see it.
d. Publish the solution & create a new Dashboard. Pin the KPI visual to this dashboard, click the elipse and set an alert to send an email when value > 0. Since the value is the current date in interger form, it should update the data triggering the alert.
I hope one of or a variation of the above will help.
Thanks for your response @tctrout and thinking about it yesterday, I came to the same conclusion. The easiest way to get around this is to refresh from within the service.
Thanks again.
I think the act of refreshing the PowerBI solution locally within the PBIX desktop version is the crux of your issue.
1. Subscriptions can be scheduled to be on refresh (the service refresh not refreshing locally then re publishing)
a. I recommend using the service scheduled refresh as opposed to doing it locally.
2. Subscriptions can be on a time schedule, to be emailed at a specific interval.
3. You can use a creative Alert to serve like a subscription, if notification only is desired.
a. Create a query in MCode to retrieve current days date. This value will not be updated unless the report model is refreshed.
b. Create DAX to compare the value created in step a is today(). DAX will always return the current day, regardless if the report model has been refreshed. Have the DAX to return the interger value of the date time when true and 0 when false.
c. Create a KPI visual leveraging the DAX created in b. I would move this to a hidden tab within the report so that the consumer wont see it.
d. Publish the solution & create a new Dashboard. Pin the KPI visual to this dashboard, click the elipse and set an alert to send an email when value > 0. Since the value is the current date in interger form, it should update the data triggering the alert.
I hope one of or a variation of the above will help.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.