Credentials are required to connect to the SQL source when using parameter for query

Hi GilbertQ ,

So I created two reports, the first one is calling stored procedures test.spTest and passing in 3 like below

let
Source = Sql.Database("server", "database", [Query="exec [test].[spTest] @SiteNo = 3"])
in
Source

The second report calling the same stored procedures but passing in the parameter SiteNo.  Both of reports are working fine in Power BI desktop.

let
Source = Sql.Database("server", "database", [Query="exec [test].[spTest] @SiteNo = " & Number.ToText(SiteNo)])
in
Source

When I publish to my dashboard, I can see the gateway and able to select the data source then refresh the first report but get the message 'not configured correctly' when turn on gateway on the second report.  This just happened recently as of June 25.  Could you please try create a simple report with one parameter and see if it works for you?  Also, I notice if the parameter I have as string then it's working but if parameter is number and I have to use Number.ToText then it's not working.  Same as using Date.ToText() then it's not working.