no rows found

2 Topics

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 Possibly not doing? // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({@Location}, 'CSLOCATION'[Location]) VAR __DS0FilterTable2 = FILTER( KEEPFILTERS(VALUES('Date Dim'[Date])), 'Date Dim'[YYYY/MM]= @Date) ) VAR __DS0Core = SUMMARIZECOLUMNS( 'CSPDETAILS'[Criteria], __DS0FilterTable, __DS0FilterTable2, "Score", 'RM'[Score], "Result", IGNORE('RM'[Result]), "Color", IGNORE('RM'[Color]) ) VAR __DS0PrimaryWindowed = TOPN(1001, __DS0Core, [Score], 0, 'CSPDETAILS'[Criteria], 1) EVALUATE __DS0PrimaryWindowed ORDER BY [Score] DESC, 'CSPDETAILS'[Criteria]
Solved
ugoriuko
4 years ago Place Report Server
2.7KViews
0likes
6Comments
Power BI report builder unable to see DAX/MDX in query design
hi, I'm trying to fetch my dataset from power bi service, the report is in direct query mode. when i go to design mode i can see my fields present..but when i drag and drop i don't see any records. I also don't see DAX and MDX dropdown in the panel. When i change my source input to import mode..i can create my paginated report. But in direct query i face this error. Please help me. Thanks
Anonymous
4 years ago Place Report Server
1.1KViews
0likes
2Comments