Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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";
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |