Get e-mail notification when power bi visual fails to load after publishing to workspace

[srilekhabngs]

Hello,

I have a power bi report with relatively 10 pages and more and page has 8-12 visuals(cards,tables,line graphs etc). I publish my report to a workspace and with each refresh of the report I have to get a mail notification if any of the visuals fails to load/any error message displayed on the visual (visual breakdown) as shown below. Is there any possibility of such functionality? any code or  approach?

[lbendlin]

Visuals don't load until there is a page rendering request.  If you want to make this part of a Unit test you would need to either use RPA to emulate a user, or run the DAX queries for each visual manually.  Note that the query success depends on a lot of factors including things you cannot influence (like current load on the capacity).  You will catch blatant errors (broken formulas) but you won't catch performance related issues (timeouts etc).

[srilekhabngs]

Thanks for the reply Mr.Super User!!

My data set has multiple tables from the same database. So i think I can run the same SQL queries that I am using in measure calculation or SELECT statements with the same fields used in Tabe/Grid visuals.

[lbendlin]

If you want to get closer to the visual you would want to run its DAX query instead of the data source's SQL query.