Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors