Power Query, Excel and SQL Server

[krish23]

Hi All,

I am fairly new to Power Query however recognize its potential in my work.

I have a sql server stored procedure that takes 2 multi-valued string parameters. I would like to create an Excel file that has a parameter sheet with 2 different tables for Param1 and Param2. I will create another Excel sheet that gets the data from the SQL Server Stored procedure passing the parameters

I used the below query for my

= Value.NativeQuery(
Source,
"EXEC [SOTeam].[sp_Excel_Test] @Jurisdictions= @param1, @ESISClaimTypes= @param2",
[param1 = PJurisdiction, param2 = PESISClaimType]
)

i created a list for Jurisdiction
= Excel.CurrentWorkbook(){[Name="Jurisdiction"]}[Content]= Excel.CurrentWorkbook(){[Name="Jurisdiction"]}[Content]

similar to above i created another list for ESISClaimType

I created parameter for PJurisdiction and i am not sure what my next steps should be and even if the above steps are right and the best and easy way.

Please help!!

Thanks again,
Krish