cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
evillarreal Frequent Visitor
Frequent Visitor

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 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!

3 REPLIES 3
Community Support Team
Community Support Team

Re: Strange SQL query being generated by PowerBI

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
evillarreal Frequent Visitor
Frequent Visitor

Re: Strange SQL query being generated by PowerBI

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

Community Support Team
Community Support Team

Re: Strange SQL query being generated by PowerBI

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.

Support Ticket.gifsubmit a support ticket

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 135 members 1,573 guests
Please welcome our newest community members: