Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
JunBICons
Frequent Visitor

Importing more than one table in a single query?

Hi everyone!
I use Blank Query and this formula to retrieve my data;

 

 

 

 

let 
    Source = (sql_instance as any) =>
    let
        Result = Sql.Database(sql_instance, "ProductionDB", [Query="SELECT * FROM Table1"])
    in
        Result
in Source

 

 

 

 

 However, I can import only Table1 in this way, and I need to import all columns of Table2, Table3, Table4, Table5, Table6 and Table7 as well in a single query -they're in the same ProductionDB database-
How should I reformulate the code to get seven tables at once? 
Thank you very much for your help in advance!

1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

Hi @JunBICons ,
not sure how the tables relate to each other, but you could either append them with a UNION ALL statgement like so:

Query="SELECT * FROM Table1 
UNION ALL SELECT * FROM Table2 
UNION ALL SELECT * FROM Table3
..."

or perform joins like so:

SELECT *
FROM Table1
LEFT JOIN Table2
ON Table1.KeyColumn=Table2.KeyColumn
LEFT JOIN Table3
ON Table1.KeyColumn=Table3.KeyColumn
...



Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

2 REPLIES 2
ImkeF
Super User
Super User

Hi @JunBICons ,
not sure I understand your requirement, but I would recommend to try the first solution.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

ImkeF
Super User
Super User

Hi @JunBICons ,
not sure how the tables relate to each other, but you could either append them with a UNION ALL statgement like so:

Query="SELECT * FROM Table1 
UNION ALL SELECT * FROM Table2 
UNION ALL SELECT * FROM Table3
..."

or perform joins like so:

SELECT *
FROM Table1
LEFT JOIN Table2
ON Table1.KeyColumn=Table2.KeyColumn
LEFT JOIN Table3
ON Table1.KeyColumn=Table3.KeyColumn
...



Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors