Forum Discussion
Import Dataflow from Json: Cross Tenant Refrence Error
For future users searching for an answer to this issue. In my instance the error came about by having to delete dataflows to remove old connections. When exporting and importing the dataflows back in they were required to be imported in order. But in doing this the dataflow "model id" was changed.
So to repoint the dataflow to the new linked dataflows you can update the exported json file text in two places. In the entities section for referenced entities update the "model id" value. Then in the referenceModel update the "id" value. Visual studio works really well in reading the JSON files.
To get these values simply create the referenced tables in a dummy dataflow and export the json and retreive the new values.
Hope this helps. It saved me multiple days of work.
Hi Isaac,
Thanks for the quick reply 😊
Even though the error says about multiple Tenants, I have only one tenant.
One thing I have seen is that I have been able to import a base Dataflow which was not referencing other dataflow. The ones which have failed are all referencing this one and othe dataflows. Now, I have read that when you import dataflows their IDs get changed so the base dataflow might have a new ID now. So just wondering if it might be do do with the fact that the other dataflows are pointing to a dataflow ID which doesnt exist anymore? If this is the case, any idea how to find the Dataflow ID ?
Thanks again
Deepak
For future users searching for an answer to this issue. In my instance the error came about by having to delete dataflows to remove old connections. When exporting and importing the dataflows back in they were required to be imported in order. But in doing this the dataflow "model id" was changed.
So to repoint the dataflow to the new linked dataflows you can update the exported json file text in two places. In the entities section for referenced entities update the "model id" value. Then in the referenceModel update the "id" value. Visual studio works really well in reading the JSON files.
To get these values simply create the referenced tables in a dummy dataflow and export the json and retreive the new values.
Hope this helps. It saved me multiple days of work.
Thanks very much dougie115 . This is what I was looking for 😀