M language(Advanced editor)

[Anonymous]

My data is stored in Azure SQL database. My database has many tables, so I want to choose datasets from the dropdown & from that selection I have to call store procedure using M query.

[v-juanli-msft]

Hi @Anonymous 

You could refer to the similar threads

Execute SQL Server Stored Procedure With User Parameter In Power BI

Stored procedure parameter call with power bi

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.