Query Folding support for Table.AddIndexColumn()


Currently a Table.AddIndexColumn() breaks the query folding towards a SQL database. This should be possible to implement. In it's simplest form this could be done with: select row_number() OVER(ORDER BY (select null) asc) as row from Table I understand there might be problems with eventual ...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

Drill through doesn't work from the total cell of a matrix visual. Please add this as well


Within a Matrix visual, you can click on each cell and you will get the drill through menu. This works on row and column totals as well, but you can't do it from the main total cell, i.e. the cell that doesn't filter on either column or row attributes. Please remove this constrain. Why? From a e...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

Query Folding support for bi-directional filters utilizing DirectQuery mode


This might be a very easy fix. The lack of Query Folding support for bi-directional filters in Direct Query is probably just an implementation bug/mistake. But as could bee seen below, the changes might be either on the Power BI Filter visual implementation (probably the easiest one) or in the Po...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes