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

 

many thanks in advance

Need Help

2 Replies

  • 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