Forum Discussion

evillarreal's avatar
evillarreal
Advocate I
8 years ago

Strange SQL query being generated by PowerBI

Hi, guys!   We have observed that some of our PowerBIs are generating a strange query that our database devs say it usually takes a very long time to execute, causing disruptions.   The hallmark ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI evillarreal,

 

Which type of datasource and connection mode you used to connect database? Can you please provide detailed information about this?

How to Get Your Question Answered Quickly

 

Regards,

Xiaoxin Sheng

  • evillarreal's avatar
    evillarreal
    Advocate I
    8 years ago

    Thanks for your reply, Anonymous!

     

    In this case, we are connecting to a Redshift database through the ODBC connector. As far as we know, we can't send SQL queries directly with the Redshift connector so that is not an option for us.

     

    If you need any more information, please tell me!

     

    Regards,

    Enrique

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi evillarreal,

       

      Is this query only appears when you use odbc driver to get data from database? If you use original redshift connector, does this query generated?

       

      If not, I think this issue should related to use odbc driver, I'd like to suggest your to open a support ticket  to get more support for this scenario.

      submit a support ticket

       

      Regards,

      Xiaoxin Sheng