Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

select * from database where id IN ( select * from database where id is not null )

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?

 


Thanks!

Need Help
Tips and Tricks

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    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