topic Having multiple Table retured from a stored procedure into power Query in Power Query

Having multiple Table retured from a stored procedure into power Query

ShirinArshadnia — Mon, 03 Jul 2023 06:37:25 GMT

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

Re: Having multiple Table retured from a stored procedure into power Query

ThxAlot — Mon, 03 Jul 2023 07:40:13 GMT

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

Re: Having multiple Table retured from a stored procedure into power Query

ShirinArshadnia — Tue, 04 Jul 2023 11:40:23 GMT

Thank You so much

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