When connecting to a Redshift database in AWS via an ODBC connection in PowerBI, the report will execute the queries already loaded into the report upon opening of the document (in the desktop version), or randomly (in the online version). If I load a new query into the report, often up to 5 copies of the single query will start to execute, in addition to unrelated queries from the report beginning to execute at the same time as well. This completely eats up the disk space and I/O operations, effectively tying up the database so nothing can actually execute. Is there a way to disable automatic execution of queries in both the Desktop and Online version of PowerBI? With the exception of a scheduled refresh and a manual query load, the report should not continually attempt to execute queries without request. Thank you!
2 Comments
- chass
Impactful Individual
Hello Alexandra, I have asked the gateway team to take a look at this. Thanks Chuck - fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
Enforcing OneLake Security on external semantic model API calls without adding security risks
Problem External applications cannot query Fabric semantic models on a user’s behalf - with OneLake RLS security rules enforced - unless the Fabric API is exposed to any and every client an authoriz...sean_cochran1 hour agoResolver INew17Views0likes0CommentsAllow ownership transfer (“Take over”) for Activator items
Activator rules run under the identity of the item’s creator. When that person leaves the organization and their account is disabled, all rules stop working silently. Unlike other Fabric items, there...ndelcastillo1 hour agoRegular VisitorNew21Views1like0CommentsRestore "no-reply" option for Power BI Subscriptions
Please add a setting in the Power BI Subscription pane to choose the sender identity. With the recent update the platform forces emails to route through the subscription owner's personal Exchange On...LenaFid4 hours agoRegular VisitorNew260Views44likes10CommentsFabric Desktop: A Local Development Experience for Microsoft Fabric
One of the biggest challenges in Microsoft Fabric today is the one branch per workspace limitation, which makes it difficult to work on multiple feature branches simultaneously without creating separ...raym854 hours agoAdvocate INew1.4KViews15likes2Comments