Forum Discussion

ShirinArshadnia's avatar
ShirinArshadnia
Icon for Helper II rankHelper II
3 years ago

Having multiple Table retured from a stored procedure into power Query

Hi everyone, is there any solution to have multiple Table retured from a stored procedure into power Query? I have a SP and it will load only  the first returened table and i Need all of them, is ...
Need Help
ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
3 years ago

It's, so far, the intrinsic limitation of PQ to receive only the first dataset returned by SP. A workround is tweak the SP as follows, if all returned dataset of the same table structure,

 

CREATE OR ALTER PROC sp_xxx
AS
BEGIN

-- First resulting dataset
SELECT * FROM XXX1

UNION ALL
-- dataset delimiter
SELECT 'DELIM','','',...

UNION ALL
-- Second resulting dataset
SELECT * FROM XXX2

END