Forum Discussion
Passing Paramaters
Hi, truman99
This is a known limitation when using DQ in SSMS
You can refer to About using DirectQuery in Power BI for more details.
Best Regards,
Community Support Team _ Eason
- truman994 years agoRegular Visitor
Thanks v-easonf-msft -- that's the thing, I'm passing two filters and the visualization is seeing them, I've confirmed using variables and Return. The weird part is that PBI sees the Domain filter and the Date filter but then only uses the Domain filter. It ignores the Date filter and instead tries to pull records for ALL dates which is throwing me over the limit.
Do you know why PBI would see a parameter and not use it?- v-easonf-msft4 years agoCommunity Support
Hi, truman99
Not fully sure what you want. Did you mean that field ‘look up date’ in the drill through pane is not filtered?
What you mean by 'using variables and Return'? Can you show relevant screenshots about the drill through pane and all the fields used in the current target page?
Best Regards,
Community Support Team _ Eason
- truman994 years agoRegular Visitor
Yeah, v-easonf-msft it is super confusing. I appreciate you looking at it.
The best way I can explain it is the first screen shot in my initial post. Each row has the right domain and the right lookup date, but then it is trying to pull the info for every date, where it ignores the lookup date.