topic Re: Using Web Request Query for Power BI Report Performance in Report Server

Using Web Request Query for Power BI Report Performance

SQuazi — Thu, 06 Feb 2025 12:24:26 GMT

Hi All,

I am trying to connect JMeter Query with Power BI Report to obtain Performance metrics.

When we execute JMeter Test for PBI Report, it is returning few Query Data as shown below.

Now we are unable to find that given querydata is associated with which section of report?

This a sample QueryData Response:

Need help on:

1) How can we interpret this data to understand which particular section/Visual is sluggish or slow?

2) Some QueryData is returning VisualIDs, how to trace them in PBI Report?

Would appreciate your help in advance. Any guideline or reference would work.

Thanks,

Saba

Re: Using Web Request Query for Power BI Report Performance

lbendlin — Fri, 07 Feb 2025 00:41:44 GMT

1. Visuals create their own dedicated DAX queries. You can try to match them, but be aware that user interactions will modify the query filters

2. Use the Embedded Playground to fetch page IDs and visual IDs

Re: Using Web Request Query for Power BI Report Performance

Anonymous — Tue, 18 Feb 2025 09:02:17 GMT

Hi, @SQuazi

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yongkang Hua

Re: Using Web Request Query for Power BI Report Performance

SQuazi — Tue, 18 Feb 2025 10:06:41 GMT

@lbendlin Can you help with example for #2 in your mention ? Where do we need to write code to fetch these visual IDs ?

Re: Using Web Request Query for Power BI Report Performance

lbendlin — Tue, 18 Feb 2025 12:20:43 GMT

The Embedded Playground provides sample code for enumeration of report pages and visuals on pages.