Forum Discussion
Solved
Performance Analyzer Query with 2 Parameters Run ok in DAX Studio, No Rows Found in Report Builder
Hi Guys, The below Query runs perfectly in DAX Studio, But returns no rows found in Report Builder. I am passing the report Parameters @Location and @Date as the query parameters What am I Pos...
So I was able to figure out what was going on.
The Table was returning empty because I had defined the parameters and hadn't passed the values.
When the values are passed, it returned all the correct values but I needed it computed for each row.
Solution
I had to repeat the query for each row I needed to evaluate using the Filter in the Dataset propertiesThanks d_gosbell I really appreciate your genuine and sincere effort at assisting me.
Cheers
So Apparently, I had to build a query for each row I was trying to format. Then I point each sell to the corresponding query I built just for the formating. You can send me a direct message for further assistance.
