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
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!
Solved! Go to Solution.
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
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
68 | |
61 | |
19 | |
17 | |
13 |