Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |