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
Exported PDF from PowerBI to not have any indents/borders
Currently, using the "Export to PDF" option in PowerBI results in two consistently buggy results: A white border/indent is generated, increasing the size of the page from 8.5x11 to 9x11.5 Sometime...EliShalev40 minutes agoNew MemberNew1View0likes0CommentsAdding a Container for Logical Grouping of Activities in Data Pipelines
Dear Team, I would like to propose a feature enhancement for Data Pipelines in Microsoft Fabric that allows the logical grouping of activities into a container. This container would serve to: Im...lukas_karlovsky1 hour agoNew MemberPlanned868Views15likes5CommentsSupport 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...Seeralan3 hours agoNew MemberNew4Views0likes0Comments