Hello everyone! Good morning!I would like to know how to use the IN followed by SELECT in the Power Query of Power Bi using ODBC.
I created this table in the data base to facilitate my ID's update in Power BI because my file exceeds 1gb and it takes a long time to read the entire query and have to update again.
When I try to create this SQL in my ODBC query it appears this error message:This type of correlated subquery pattern is not supported due to internal error
But when I put the fixed ID's it normally accepts after the IN.Like this:select distinct id from datamart.d_user where id in (1234,123,12345,1233,1111,1111111,122312312321)
Would you know if there is any other way to make the Power Query accept my list of ID's as I did in dbeaver according to the photo below?
Does it work with an inner join?
select distinct a.id
from datamart.d_user a inner join
datamart.usuarios b on b.id = a.id
where b.id is not null
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!