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
Expose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer1 hour agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos1 hour agoNew MemberNew3Views0likes0CommentsEnable Export and Programmatic Access to Copilot Narrative Text
Copilot Narratives provide valuable AI-generated insights directly within Power BI reports. However, there is currently no straightforward way to export, copy, or programmatically retrieve the exact ...Mario_A_S_13 hours agoNew MemberNew21Views3likes0CommentsDynamic Labels for Subtotals and Totals in Power BI Matrices
Power BI should support dynamic expressions for subtotal and total labels in Matrix visuals. Currently, subtotal labels are static, which limits report usability and forces report authors to implemen...KellyMc3 hours agoNew MemberNew19Views1like1Comment