Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

Hello,   I have a report that is scheduled to refresh everyday and it has been working fine until yesterday.  I noticed that it failed to refresh and it looked like gateway not configured correctly...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

It seems to me when use Number.ToText(0) or Date.ToText() then only work in desktop and it's not working when publish.  This just happened recently.  Not sure if need to report this issue.

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Can you show us what your data types are set to in the Parameters in your PBIX?
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi GilbertQ ,

     

    This is my steps:

     

    1. Created a stored procedures called spTestVy (see below)

     

     

    2.  In my Power BI report, added Parameter called 'SiteNo' with type interger

     

     

    3.  In my power query, I have the following.  Need to use Number.ToText() to convert.  If not, I'm getting error can't concatenate string with number

     

     

    4.  In my report, only display this

     

     

    5.  Published the report to my dashboard.  Go to settings -> under Gateway connection, I get the message not configured correctly.

     

     

    6.  Now if I change my parameter type to string then the gateway can see datasource.

     

     

     

     

    Something changed because it was working before when having the paramter as integer.