Vastly different queries on desktop and after publishing the report

[Anonymous]

My report generates nice and fast queries on desktop but slow and bloated queries after publishing.

I checked the queries with sql profiler when debugging poor performance. The report loads everything fast on desktop using direct query but the generated sql queries change to something terrible after publishing. The desktop manages to fetch same data in a couple on seconds but the published report takes ~20 s.

The generated queries the Power BI actually makes are 35 lines vs. 106 lines.

I don't think there is anything I can do about it. I wish Microsoft could.

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

The refresh of the dataset in Power BI Service is different from desktop, you could refer to below link about the Power BI Security:

https://docs.microsoft.com/en-us/power-bi/service-admin-power-bi-security

Regards,

Daniel He

[Anonymous]

Hi and thanks for your answer!

It's good to know, even though it does not actually solve the problem. I will accept this as an answer anyway since I don't expect any serious follow up. The fact remains that the published reports produce slower queries.