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.
Hello,
I'm trying to connect ODBC and have a question if it is possible to get certain fields from one table and all fields from other tables.
As it takes too much time to load data from saleitems, I want to get only necessary fields; FieldA and FieldB.
And I want all three tables be individual without joining which means, I don't want to inner join saleitems, account, and brand, but I should get three individual tables.
I've checked all the SQL statement, but seems like all are to join the tables to make a one merged table in the end.
Thank you in advance.
Solved! Go to Solution.
@Anonymous , In connection advance property you have an option to give a query, you can create a new connection and add that table as query
@Anonymous , No, The one where you want less column to create a connection query. rest two add as tables
@Anonymous , In connection advance property you have an option to give a query, you can create a new connection and add that table as query
Do you mean it is possible to separate the three queries for three tables with semicolon in the SQL Statement box?
So.. my query should be as below, right?
SELECT FieldA, FieldB FROM Org1.saleitems;
SELECT * FROM Org2.account;
SELECT * FROM Org2.brand;
@Anonymous , No, The one where you want less column to create a connection query. rest two add as tables
hi can you clarify what you mean about checking the sql statement, do 3 different connections for the 3 tables, but write the sql code for each one in advanced options to reduce the load and push the compute back to the server the db is sitting on.
Proud to be a Super User!
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |