I propose the ability to pass a custom dax code that returns a table as the source for a visual(primarily for table visual). This is especially prevalent when the dax code can be ran as a table return in the dax query view but cannot be applied to the visual because calculated tables does not work with direct query mode and we need to switch to import. This eliminates the need to create calculated tables or exporting the table from power bi and further aggregating in excel because of relationship and model limitations.
This will be an enhancement to the current visual calculation where you can enter dax to the visual as a new column and instead it would be the full table would be based on the custom dax code
This can also help us get around the 1000000 limit when trying to query a sql warehouse by optimizing the query and not relying on the power bi generated one.
Related issues:
https://community.fabric.microsoft.com/t5/Desktop/Error-Resultset-of-a-query-to-external-data-source...
on:
Add native Dev/Test/UAT/Prod semantic model compar...
on:
Computed Columns in Fabric Data Warehouse
LiLiu_Fabric
on:
Deployment Pipeline Run in Fabric monitor