Having multiple Table retured from a stored procedure into power Query

[ShirinArshadnia]

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 there any solution or I should seperate them in another Stored procedure?

many thanks in advance

[ShirinArshadnia]

Thank You so much

but all returned dataset are not in the same table structure.

[ThxAlot]

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