Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 of a query is a WHERE condition in the style of : where POSITION((($1))::text IN ("column")::text) = ($2)
The weird thing is that in any query using that table, we aren't filtering by "column", so does anybody know when is PowerBI generating a query like that?
Thank you!
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
Thanks for your reply, @v-shex-msft!
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
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.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |