Forum Discussion
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...
I have a similar problem.
Same reports works on desktop PBI but does not work when trying to update data from web using a gateway.
Examples:
I build the query with strings/variables concatenation.
Depending how I set the concatenated variable, it works on both the environments or only from desktop:
variable = "" WORKS
variable = if 1=1 then "" else "" WORKS ONLY FROM DESKTOP
variable = "'" & "0" & "'" WORKS
variable = "'" & Number.ToText(0) & "'" WORKS ONLY FROM DESKTOP
(These examples are real tests made after I became desperate)
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.