Forum Discussion
Error when Refreshing SQL Data
Just proved it is not the case when issue with a simple select getdate, and case when getdate()='2017-01-01' then 1 else 2 END as test.
it refreshed fine.
So I still have a simple model based on 4 tables from the same server one data source to pass credentials to (which suceed) all under the schema "dbo".
I have removed the view which then alloud the data to load OK. but reintroducing the vue is causing it to fail. I have tried stipping out elements of the view to simplify it, but it was still failing. I am off now for a couple of weeks (lucky me) so hopefully someone else will get this resovled/
Well I've made slight progress. Still don't what is causing it to error but I've loaded in three views (not using a stored procedure), each time importing a single view, uploading to the report server, scheduling a refresh with success. I've got to three views in and it is still fine so far (fingers crossed for tomorrow).