Imagin we have a Power BI report that an end user uses and when the data source modifies it refreshes a PBI dataset using an automatic flow. As we use PBI Pro version we have a 8 time limit per 24 hrs but we want to set up a notification on the same rpoert page for any user (not PBI DS owner) like a card visual that alerts him when the 8 times limit reached per cycle. Again, I reiterate it that we dont want a TEMAS / EMAIL or anyother instruments to get notification because the end user (not DS owner) must instantly notified on the same report page when the maximum no. of refreshes reached.
I would appreciate your help
Solved! Go to Solution.
There is no functionality at the moment that would allow you to do this. But what is the use case, why do you need this on the report itself vs a message of some sort? This is not an ask that I've seen before.
Thank you @d_gosbell for the reply,
In fact we have designed a Power apps visual to trigger modification on a sharePoint list. Now we need to show to the user on the same report (same visual page) how many times the SharePoint list(or PBI dataset as a result) have changes!?
Two reason for not using other methods of Push notifications to the user email address:
1. it will be used not by one or specific number of end users (it should work like a stand alone report)
2. the users dont want to receive notifications elsewhere(not as an email or TEAMS msg)
I would really appreciate it if you can share your great ideas!
As I mentioned there is no functionality which could display an alert on the page if the 8 refresh limit has been hit. You could maybe put the last refreshed datetime on your report so the user could see that it was not up to date, but they would not know why.
Otherwise you could look at using a premium capacity or PPU licenses instead of using Pro. Then you don't have the 8 refresh limit.
Or you could try using and endpoint like Azure SQL instead of a sharepoint list and then you could build your model in Direct Query mode so that it always queries the latest data and you don't need to refresh at all.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.