I have a datasource view DSV1. It points to a datasource DS1 that is considered the "primary".
I have created a Report Model that uses DSV1 (and thus uses DS1)
I created a new datasource, DS2 that I would like to use instead of DS1. (I can't just modify DS1 because if I modify it, it will overwrite it when we go to our Production environment and break that datasource)
So, I can go into DSV1 and change all the references from DS1 to DS2.
But that's where the problem lies.
When I try to build, I get the following error:
"The Table property of the Entity "E1" refers to the Table "dbo_View", which is not in the primary data source."
Somehow, the entity is tied to the "primary" datasource. When I change it back to DS1, everything works fine. Any thoughts? What can I do?
Here is what I've noticed:
If I look at the code for the Data Source DS1, the XML shows an <ID> tag and a <NAME> tag.
In SSRS, it is requiring that the ID be named "DS1", but the name can be whatever I want.
So if I change the name, it looks like I can deploy no problem without overwriting my old Datasource, but I just wish I could have these two pieces updated without a problem.
Any idea why this is?
No comments:
Post a Comment