Assume a data model with one fact table containing sales data and one dim table containing customers. If in direct query mode a filter concerning customer name is applied to a report page, then the resulting query which is sent to the SQL Server Backend contains a string predicate with that name. If the execution plan could send the associated ID instead, the resulting execution plan could take many advantages, especially in combination with clustered columnstore indexes (e.g. aggregate pushdown). Is this possible?
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Support Native SQL LIKE / NOT LIKE Wildcard Filtering Across Power BI Reports
Description Currently, Power BI does not provide a native way for report consumers to perform dynamic SQL-style wildcard filtering using patterns such as LIKE '____' - Above return all values wit...Seeralan1 hour agoNew MemberNew4Views0likes0CommentsRetain Matrix/Table Scroll Position When Returning from Drillthrough
Description: Currently, when users drill through from a Matrix or Table visual to a detailed page and then use the Back button to return, the report navigates back to the source page but resets the ...Pruthviraj152 hours agoNew MemberNew13Views0likes0Comments