Forum Discussion

xhead's avatar
xhead
Helper II
4 years ago
Solved

Dataflows deployed from a Deployment Pipeline - invalid data source

I have created a dataflow that has a single data source (a SQL database). Here it is in lineage view.       I am using a Power BI Deployment Pipeline to deploy that dataflow from Workspace ...
Dataflow
Need Help
  • xhead's avatar
    xhead
    4 years ago

    I have reported this issue through a Power BI Support ticket, and it has been acknowledged as a bug which involves the Data Flow team, the Lineage team, and the Deployment team. The estimated time the bug will be resolved is Feb 2022.

     

    I have been able to work around this issue partially by parameterizing the database and server names in the connection, and using deployment rules on the parameter values in the deployment. In the target workspace, the old data source dependency is shown in the lineage view, but that "phantom" data source does not need to be mapped to a data gateway in the settings of the data flow. 

     

    When I didn't parameterize the data source server and database, I needed to map the "phantom" data source to a data gateway (and the same data gateway) as the valid data source. 

     

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi xhead ,

 

This is by design. When I export the dataflow from workspace A as a .json file, and then use that model in workspace B and modify the data source, then the old data source will still appear as lineage for the dataflow. And it will still appear in the Setting page in the gateway drop-down.

 

  

 

This is mentioned in the documentation.

 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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