topic Power BI refreshing taking long time to display results after applying query string in the URL in Report Server

Power BI refreshing taking long time to display results after applying query string in the URL

vignesh-490 — Fri, 06 Aug 2021 07:00:14 GMT

Power BI Map is loading very slow after passing Query string parameter in the URL.

Are there anyways to improve the performance of the map.

Re: Power BI refreshing taking long time to display results after applying query string in the URL

lbendlin — Fri, 06 Aug 2021 22:22:42 GMT

Is the field in the URL query string used in the map visual?

Re: Power BI refreshing taking long time to display results after applying query string in the URL

vignesh-490 — Mon, 09 Aug 2021 06:06:39 GMT

Yes , I'm appending the parameters in the URL .

Anyways to improve the performance on querying.

Re: Power BI refreshing taking long time to display results after applying query string in the URL

lbendlin — Mon, 09 Aug 2021 13:18:06 GMT

Use Performance Analyzer and DAX Studio to investigate the performance of the queries in the affected visual.

Re: Power BI refreshing taking long time to display results after applying query string in the URL

v-henryk-mstf — Tue, 10 Aug 2021 08:35:50 GMT

Hi vignesh-490 ,

According to your description, first update to the latest version of PBIRS. There are several options for monitoring the performance of the report server, which can help identify the cause of the slowness.
a.Use performance monitoring tools to monitor server performance, he can evaluate server activity, observe trends, diagnose system bottlenecks, and collect data
b.The report service stores the execution data in multiple tables in the report server database