cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Galapaka Frequent Visitor
Frequent Visitor

Vastly different queries on desktop and after publishing the report

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Vastly different queries on desktop and after publishing the report

Hi @Galapaka ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Vastly different queries on desktop and after publishing the report

Hi @Galapaka ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Galapaka Frequent Visitor
Frequent Visitor

Re: Vastly different queries on desktop and after publishing the report

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.