Forum Discussion
Solved
Loading multiple tables from one SQL query
Take the following PowerQuery M code: let
QueryResult = Sql.Database("Server", "database", [Query="select * from MyTable1; select * from MyTable2;"])
in
QueryResult This wil...
Then you would have to package them (for example as JSON or XML) and send them over as a string that you would then untangle in Power Query. And this is where the fun stops - Power Query cannot create multiple tables from a single query.
What's your business case?
PwerQueryKees
Super User
Super UserWhy not have 2 sql queries? What are you trying to achieve?
