Forum Discussion
Zhinee
Helper III
Helper IIIStop 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: IsSes...
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.
lbendlin
Super User
Super UserIn 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.
ZhineeHelper III
Helper IIIso 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?
- lbendlin
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.