Forum Discussion
Decrease amount of data received from Direct Query
You can use the parameter to get the updated data for a particular period.
please have a look on below
https://community.powerbi.com/t5/Desktop/How-to-restrict-data-in-query-editor/td-p/406415
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points
Regards,
Hello apentyala ,
I checked your suggestions.
Because I'm not using Query Editor to transform the Query tables, the first link doesn't help me.
The second page is very interesting; due to that, I have just learned that tables only show 500 rows before loading again. However, it doesn't work in my case, since a simple refresh of reselecting one slicer causes the table to load for at least 5 min (it's also way longer when nothing is selected, even though I've created a measure to avoid showing any rows in the table when nothing is selected).
If anyone could tell me how to prevent a visual from loading/ refreshing when nothing is selected, I would appreciate it greatly.
Did you ever find a satisfactory solution for this? I'm in the same boat; using DirectQuery and I don't want to bother my poor database with heavy queries until the data has been filtered down enough.
The only solution I've been considering is to reduce the maximum row limit for DirectQuery on a capacity level. If you go to the Power BI service -> open the Admin Portal -> click on your capacity's name and then scroll down, you'll find the "Max Intermediate Row Count" setting where you can set it to your desired number.
That will reduce the amount of data for everything connected to that capacity though. I would like to do something similar, but just for a single visual. Any ideas out there?