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
- chassImpactful IndividualHello Alexandra, I have asked the gateway team to take a look at this. Thanks Chuck
- fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
Option to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir154 minutes agoMicrosoft EmployeeNew19Views8likes0CommentsAllow selecting specific Fabric items to pull when using Update from Git
I’d like to suggest adding selective item deployment to Microsoft Fabric’s Update from Git experience. Today, when a Fabric workspace is connected to Git, Update from Git is primarily focused on syn...dprenc_elixirr3 hours agoAdvocate INew7Views0likes0CommentsDependency-aware Update from Git operations
I’d like to suggest improving Update from Git in Microsoft Fabric so that it becomes more dependency-aware during deployments. Git deployment can become fragile when multiple Fabric items depend on ...dprenc_elixirr3 hours agoAdvocate INew4Views0likes0CommentsAPI for Get Refresh Schedule of Dataflows
Currently, there is no way to get the actual refresh schedules of dataflows through the API. It is very important to see the coordination of dataflow and dataset refresh schedules. This seems like a...Andrew_Foulk24 hours agoNew MemberNew590Views28likes5CommentsExport Report Access Matrix for Workspace Admins
Title Allow Workspace Admins to Export Report Access and Permissions Without Tenant Admin Rights Product Microsoft Fabric / Power BI Service Business Need As a Workspace Administrator, I need a ...DonLloydLopez5 hours agoNew MemberNew6Views0likes0Comments