title: Power BI Report: How to pass Dynamic Values to Parameters in Report Made with Stored Procedure
body: <pre><code>let
      Source = Sql.Database(MyServer, MyDatabase, [Query="EXEC  [dbo].[spEmployeesRead] '" &amp; ActionCode &amp; "', '" &amp; UserID &amp; "', NULL, NULL, NULL, NULL, '" &amp; Alphabet &amp; "'"])
  in
      Source
  </code></pre>
  
  <p>Above is my Stored Procedure in Query Editor its running fine and getting data as i am passing all parameters dynamically including Server Name and Databasename. My Question is I have Saved and Publish the Report to Power BI Service and then Open the Report and from File Menu get Embed Code and pass parameters to this Report URL so i can access this from other Applications and that Application will pass the parameter values dynamically but seems like things are not working correctly. Can anybody check where i am wrong.</p>
  
  <pre><code>https://app.powerbi.com/reportEmbed?reportId=341f891b-93f8-490a-9a91-62f12f783e2c&amp;groupId=4791121d-01f2-49ad-99fc-9fa3bab7fc3f&amp;autoAuth=true&amp;filter=MyServer eq 'MSSQLSERVER2017' and MyDatabase eq 'TestDB' and EmployeesList/ActionCode eq '1' and EmployeesList/UserID eq '1' and EmployeesList/Alphabet eq 'All'
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/JwPzL.png" rel="nofollow noreferrer">Attached Image</a>
  <a href="https://i.stack.imgur.com/6B0sJ.png" rel="nofollow noreferrer">Attached Image</a></p>