Using Import Model

[Imrans123]

Hello,  

I was wondering if anyone could help me. I have multiple data SQL Server data sources all with the same tables. I want to create a dataflow against each source all having their own respective data gateway. I have a couple of queries where I am bringing in data using native query and some power query steps. 

I completed one dataflow and I wanted to export that as json and import the model for the next source. I took the json file, did find and replace to replace the server and database name with the new source. However, when I try to load the data, it brings in all the field names as I want it, but when I go edit table, it says "

We encountered an unexpected error."

The mashup text is showing the wrong server and database name for the native query step which I had changed via find and replace. Also, I am unable to choose the data gateway that I would like to use for these native queries., 

Did anyone have this issue?

[v-zhangti]

Hi, @Imrans123 

Could you please provide a screenshot of the reported error for reference? What does the page look like where you can't select the data gateway you want to use for these local queries? If so, I would like to be able to provide it.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.