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!
ToddChitt
on:
Copy Job needs more functionality
on:
Support for Signed GitHub Commits
on:
Bug: Web URL Conditional Formatting Ignores "Show ...
on:
Apply Conditional Formatting to All Columns/Series...
yicw
on:
In Fabric view, let us assign workspace colors bas...
on:
Introducing Excel-Style Table in Power BI