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

ODBC SQL import best practices

Hi All,

 

I was wondering what is the best prctice for ODBC queries

 

I am looking to query two large tables one contains an active status and one doesnt ....

 

If I go to Get data > ODBC > Advanced and type in the SQL below to join the two tables is this the best way or is it best to query both tables seperatly and edit / merge them in power BI before running the close and load ???

than kyou in advance

 

SELECT
a.cust_code,
a.date_created,
a.guarantee_end_date,
a.inv_status_code,
a.invn_code,
a.model,
a.num,
a.prem_code,
a.status_ind,
a.styp_code,
b.cust_code_owner,
b.code,
b.zipc_code,
b.post_in_code,
b.postcode_sector_id
FROM database1.customer a
LEFT OUTER JOIN database1.premise b
ON a.cust_code = b.cust_code_owner
AND a.prem_code = b.code
WHERE a.status_ind ="A"
AND a.styp_code = "ABA"
OR a.styp_code = "ABB"
OR a.styp_code = "ABC";

1 REPLY 1
NickNg278 Senior Member
Senior Member

Re: ODBC SQL import best practices

@mjohnsonuk

From my experience, it is better to write your own custom SQL. You could do the latter but sometimes ODBC does not perform query folding correctly, hence it will perform the join in your local memory instead of at the server. 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 51 members 1,004 guests
Please welcome our newest community members: