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.
Hi All,
I have a power bi report that is pulling data via SQL server (direct query) and is working fine when used in the Power BI app. When I view this report on Power BI desktop all visuals work apart from one and I receive the below error;
"The query result is too large. Consider removing unused columns, adding visual filters, or reducing the number of string type columns."
My data set is not particularly large and I do not want to do any of the above-mentioned steps, I also find it weird all other visuals are working just fine and are coming from the same data set.
Any ideas on how to resolve this?
Many thanks,
E
Hi @Serdet ,
Check the similar thread below:
https://community.powerbi.com/t5/Service/The-query-result-is-too-large/td-p/618659
@Serdet , can use sql server profiler and check the query.
refer
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages
try query reduction
https://www.youtube.com/watch?v=4kVw0eaz5Ws
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |