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
Let Workspace Admins manage Fabric Policies
For example, allow a Workspace Admin to grant other identities the Contributor role, while also granting them higher privileges in certain areas, e.g. List Workspace role permissions (without resha...frithjof_v47 minutes agoCommunity ChampionNew40Views0likes3CommentsSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull221 hour agoAdvocate INew49Views1like3CommentsShow Refreshing indicator in workspace for semantic model refreshes from pipelines and XMLA
When I start a semantic model refresh by hand ("Refresh now") or from a schedule, the workspace list shows a spinning refresh icon next to the model. That way, anyone can see a refresh is running. T...JDownes3 hours agoRegular VisitorNew7Views0likes0CommentsREST API - exclude hidden report pages
For the "Reports - Get Pages" REST API call, exclude hidden report pages or indicate that the page is hidden.alec_johnson5 hours agoNew MemberNeeds Votes643Views32likes10Comments