Skip to main content
Microsoft Idea

Issues

Under Review

Redshift ODBC Connection Multiple Queries

Vote (4) Share
's profile image

on 25 May 2016 00:21:38

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!

Comments (1)
's profile image Profile Picture

sadf sdf on 05 Jul 2020 22:23:19

RE: Redshift ODBC Connection Multiple Queries

Hello Alexandra,
I have asked the gateway team to take a look at this.
Thanks
Chuck