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 ...
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...
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...