Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Open PBIX file executes the query multiple times

We have a connection via ODBC to a Redshift environment and run queries against them.   We have an issue whereby the desktop is kicking off the sql query multiple times and causing CPU and disk spa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi and thanks for the response.

 

I think our set up must be different. We use open VPN to connect to the 3rd party where are data is held. 

I have had our 3rd party monitor what happens at each stage and originally, when I opened a file it started multiple jobs there side. Once I had disabled the preview option, it started nothing on opening, but did the multiple jobs when I click edit queries. 

 

I have monitor grabs from them but am struggling to work out how to link them in here. 

 

I tested with other developers in our company and the same happened. When they opened a Power BI file with a connecction to Redshift, it kicked off a process for 28 minutes. In that scenario, their job only ran once. 

 

When I click on edit queries, I get a message in the bottom saying 'WAITING FOR DSN='<OUR REDSHIFT>'. (CLICK HERE TO CANCEL) - if I cancel, we can see that the job(s) continue to run on the redshift side.

 

Thanks for any suggestions.

 

 

Sharpiebizkit's avatar
Sharpiebizkit
Icon for Advocate I rankAdvocate I
8 years ago

KirstenJude is right. I have a similar setup where I use an ODBC connection to hit an AWS cloud source. We hit a virtualization layer that connects to Redshift, and Hive via Presto. The behavior described happens to me as well. Power BI is kicking off multiple instances of the query when clicking "Edit Query". It causes frequent timeout errors.