cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DakkoN_Hot
New Member

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

DakkoN_Hot_1-1656587391346.png

 

DakkoN_Hot_3-1656587744990.png

 

 

DakkoN_Hot_2-1656587614230.png

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?

DakkoN_Hot_0-1656587211093.png

 


Thanks!

1 REPLY 1
AlexisOlson
Super User
Super User

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

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Kudoed Authors