Forum Discussion
Pass parameter in M query to retrieve data from SQL Server database
We are using Power BI Desktop for Report Server (May 2021). Within the query editor we are trying to create a query that retrieves data from an SQL Server database and have it filtered by a parameter...
Hi Lorenz33 ,
Yes, you can call query parameter when you implement SQL statement in power bi, you can also refer to this:
https://reevessmith.wordpress.com/2014/08/19/power-query-and-stored-procedures-with-parameters/
Pass parameter to SQL Queries statement using Power BI
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.