Thank you - I thought I had the parameter set to text when I published to the Service but it must have been published as Any. I published as text and was able to edit the parameter. I did get an error; however, this could be due to a different issue I am having with unsupported data sources for refresh...
Maybe you can help with this issue I am having:
I have 30 reports that have typically 5+ SQL Server connections to a server that needs to be migrated due to a version update of our ERP. I've been trying to engineer a solution to be able to toggle back and fourth between servers for all of the connections in all of my reports using the following logic:
1. I created a table with two columns [Server],[Status] (status being a true/false identifier to choose which server to use)
2. I created a stored procedure to change the [Status] between different servers
3. I connect to the table in all reports, filter for [Status] = 1, then drill down on the [Server] to get the output of the server name
4. I then use the name of the query in step 3 as the source for all of my SQL Server connections.
I can get the report to refresh in the desktop after toggling between servers but when I publish to the web I cannot get the refresh schedule to work. Each sql source shows the same error:
Query contains unknown or unsupported data sources. SQL, ************.norco.com;DataAnalytics
I used the ********* to replace the actual server name
Any idea's on how I can use my intended idea and work around this error? I've tested this with the server name only and with the full domain as well. Both times I get the same error. What's interesting is that the server name in the error does not change when I toggle between the two servers (server1 is published and the error is still associated with server2) which leads me to believe this is a gateway issue.
