Query Diagnostics page

[mark_carlisle]

How has the Query Diagnostics page been built in the Partner Dashboard Power BI report? Tried searching but nothing obvious is standing out. I'd like to do something similar for reports that I'm building for our organisation.

[Anonymous]

@mark_carlisle,

Do you want to know how to make conditional formatting in the above report?



If so, you can review the steps in the following article.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Regards,
Lydia

[mark_carlisle]

No the conditional formatting I'm happy with doing. What I want to understand is how Microsoft have managed to retrieve the query name, success or error messages, and the time taken to execute the query. This information would be great to display to end users on our reports should they need to log an issue.

[Anonymous]

@mark_carlisle,

Where do you get the report as shown in above screenshot?

Regards,
Lydia

[mark_carlisle]

The report is from the Partner Center Analytics app for Power BI.

[Anonymous · Accepted solution]

@mark_carlisle，

There is no official article about this information, I think the content pack invokes Partner Center REST API in the backgroud. And the query exec time should equal to query end time- query start time.

Regards,
Lydia