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

Question

Hello,&nbsp;I have a report that is scheduled to refresh everyday and it has been working fine until yesterday.&nbsp; I noticed that it failed to refresh and it looked like gateway not configured correctly (see image below).&nbsp; The gateway is fine for other report.&nbsp; I could not figure out what caused the problem so I changed the query then able to select the gateway but getting another error 'Credentials are required to connect to the SQL source' when trying to refresh.&nbsp; &nbsp;My query has parameter.&nbsp; If I remove the parameter then I'm able to refresh the dataset.&nbsp; I don't understand.&nbsp; I can refresh the report with parameter query before.&nbsp; Not sure what happened or what I need to change in order for this to work again.&nbsp; Please advise.&nbsp;ThanksVy&nbsp;&nbsp;&nbsp;

itsnev · Answer

I'm having the same problem, was working fine last week not getting this error but only for some of the reports.

I think Microsoft may have PATCH something and broke it as usual. Hope they fix this soon as refreshing manually now.

gilbertq · Answer

Hi thereYou will have to turn off the Gateway option for it to work?

anonymous · Answer

Hi&nbsp;GilbertQ&nbsp;,&nbsp;I turned off the Gateway but still getting this error 'Credentials are required to connect to the SQL source.' when trying to refresh.&nbsp; Please advise what else can I try.&nbsp;ThanksVy&nbsp;

gilbertq · Answer

Can you post the connection string to the SQL Server?As well as the actual error message?

anonymous · Answer

Hi&nbsp;GilbertQ&nbsp;,&nbsp;So I created two reports, the first one is calling stored procedures test.spTest and passing in 3 like below&nbsp;letSource = Sql.Database("server", "database", [Query="exec [test].[spTest] @SiteNo = 3"])inSource&nbsp;The second report calling the same stored procedures but passing in the parameter SiteNo.&nbsp; Both of reports are working fine in Power BI desktop.&nbsp;letSource = Sql.Database("server", "database", [Query="exec [test].[spTest] @SiteNo = " &amp; Number.ToText(SiteNo)])inSource&nbsp;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.&nbsp; This just happened recently as of June 25.&nbsp; Could you please try create a simple report with one parameter and see if it works for you?&nbsp; 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.&nbsp; Same as using Date.ToText() then it's not working.

Forum Discussion

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

10 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Slicer requirement

Destruction of credentials

Two Parameters are required in Paginated Report, pls help

Query Editor requires credentials?