JoJoJoJoJoJoJo
1 year agoNew Member
Status:
New
Merge slicer and visual queries in DirectQuery mode when sourced from the same table
In DirectQuery mode, Power BI sends separate queries for slicers and visuals, even when both are based on the same table. This results in redundant full-table scans and unnecessary load on the data source. It would be more efficient if Power BI could merge these into a single query or allow a deferred visual load option (e.g., a button or toggle) so visuals only query after a slicer selection is made. This would significantly reduce backend reads and improve performance in enterprise environments where import mode is not allowed.
As it stands, you enforce at least two reads of every row in the base table, every time the page loads before a slicer value can cause a third read to restrict the data selection.
No CommentsBe the first to comment
Recent ideas
Add Centralized Health, Freshness Monitoring, and Alerts for OneLake Shortcuts
Microsoft Fabric should provide a centralized health-monitoring experience for OneLake Shortcuts across workspaces and data sources. As organizations adopt OneLake Shortcuts at enterprise scale, hun...mourakshit3 hours agoNew MemberNew27Views3likes1CommentCustom Colors for Workspaces and Items
In the new Fabric view, each workspace is given a color, and any open items from that workspace are given the same color in the bar at the top. The issue is that some colors are much too similar and ...tanner_strickle3 hours agoRegular VisitorNew5Views0likes0CommentsSlicer Search Bar: Keep "Select All" Visible During Search
When using the search bar in a slicer, the "Select All" option disappears from the list, making it impossible to select all matching results at once. Users are forced to manually check each item indi...Sivasankarir3 hours agoNew MemberNew2.6KViews12likes1CommentUpgrade Copilot Integration in PBI Desktop/Service
The copilot functionality in Power BI Desktop / Service lacks functionality to help build / change and develop reports. For example, you cannot change formatting of a table (of any sort) to have Copi...Steven_14 hours agoNew MemberNew27Views3likes0CommentsSelect All in text slicer that contain a string
I have a slicer with a text field and Select All is enabled. But Select All is only available when the text in the search is empty. If I want to select all fields that contain a string, i have to typ...nemecd5 hours agoNew MemberNew6Views0likes0Comments