N/APosted on - 03/12/2013
In SQL 2005 there is a schema and I am a supporter of it and love to exercise Schemas for both companies as well as for safety. But I have got that performance point Planning Modeler does not show to similar schemas as well as I did. First time I received this error message which you can below. How I can resolve it?
Server failed to return the table schema from source database. (Error code: PerformancePoint_225000210)
Getting table schema for table Customer from database AdventureWorks on server SQL1DEV1 failed.
The server failed to return the table schema from the source database.
In response to your question I would say, I am not very sure if I can give a perfect solution but this can be a work around for this issue. This error anyway comes whether you have built your data source from Database or from Data Source View. A workaround could be to build some views in DBO schema, but that could be very big trouble if you need to affect a huge number of tables or views. But in order to solve the issue you could give it a try.
Hope this will help you. Thanks.