Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

get a notification on the same Power BI (Pro version) report page (not an email notification)

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 hr...
notification on the report
Power Automate
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    What we ended up finally:

    CALCULATE(COUNTROWS('tablename'),KEEPFILTERS([last update time]==TODAY()))

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks!

Direct query is not possible on SP unfortunately!