Hi, When publishing projects into new tenant projects a new reporting connection get created suffixed with '- copy'.
My issue is I need the newly published cubes to look at the original reporting connection, at the moment I have to go into each individual cube and replace the tables I am using with the same tables from the original connection, is there a way I can just tell the cubes to use another reporting connection without checking out and editing each one?
Regards
Mike
I believe you are referring to your data connector as "reporting connection" and the target project already has a data connector with the same name. Having the data connectors named similarly does not make them identical, which is why the published data connector is renamed. The only exception would have been if both data connectors were published from the same project but at different times. It is not possible for the newly published cube to point to a different data connector without manually re-wiring it. With that said, if both data connectors are similar, the Re-Wiring process should not be very complicated or time consuming.
Another option you could consider is to publish without references, which will use the data connector in the source project but may require an adjustment of the user permissions.
A new feature request (#66571) is created to support re-wiring of data flow during the publishing process.