Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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).
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.
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.