Forum Discussion
get a notification on the same Power BI (Pro version) report page (not an email notification)
What we ended up finally:
CALCULATE(COUNTROWS('tablename'),KEEPFILTERS([last update time]==TODAY()))
Super UserThere 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!
- d_gosbell
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.
Thanks!
Direct query is not possible on SP unfortunately!