Forum Discussion
Stop child visual from querying all rows when parent selection is empty
My parent table is SESSION_TRANS, and my child visual is JOBLET. I want the child visual to show nothing if the user doesn’t click on any row in the session table.
I created this measure:
Then I applied a visual-level filter on the joblet visual: IsSessionSelected = 1.
This works when the session is limited (for example, sessions in the past few hours). But if I clear the filter so that all sessions are shown, the joblet visual throws this error:
"Resultset of a query to external data source exceeded the maximum allowed size of 100,000 rows."
I understand this is because the joblet visual has too many records due to no limit on the sessions.
It seems like the joblet is still loading data behind the scenes even when IsSessionSelected = 0.
I am using DirectQuery mode.
How can I address this?
This article may help.
DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
- One million row intermediate result limit. Any query (or intermediate operation) that returns more than 1,000,000 rows fails. Premium capacities can raise this limit—see Max Intermediate Row Set Count.
4 Replies
In Power BI, "nothing selected" is the same as "everything selected". That is by design, for better or for worse.
Have a mandatory filter that keeps the rowcount below 1 million.
so I added a filter to joblet viusal - I drag joblet id and the type is Top N,
I choose Top 1000 count of joblet id
I am still seeing the error, what would be the right way to do this?This article may help.
DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
- One million row intermediate result limit. Any query (or intermediate operation) that returns more than 1,000,000 rows fails. Premium capacities can raise this limit—see Max Intermediate Row Set Count.
Hi Zhinee ,
Thank you lbendlin for your inputs.We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.
