cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cphilly
Frequent Visitor

Subscriptions not triggering on manual refresh...

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

1 ACCEPTED SOLUTION
tctrout
Resolver III
Resolver III

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.

View solution in original post

2 REPLIES 2
cphilly
Frequent Visitor

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.

tctrout
Resolver III
Resolver III

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors