Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Change Data Lineage from Web Interface

Hi, I would like to ask if there is a way to change the data lineage of a power bi dashboard from one to another. Both sources are cloud servers and should have the same structure and they are all in...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,
    You can follow my steps below to open power query online and then go to the interface to change the connection of the data source, in this case you need to make sure that the table structure is the same between your data sources.

     

     

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Tom Shen

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

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

We can change the data lineage in the web ui, we have to use dataflow in the power bi server to do it.

Let's take SharePoint Cloud as an example.

 

 

 

At this point I'd like to source test2 from 888, but I'd like to use data source 666, and we can go into the power query in dataflow and change the data source to make sure that we're switching to a different data source.

At this point, we need to make sure that the structure of the table is the same, otherwise we may have problems.

Authentication is re-verified when the data source is changed.

 

Here, due to environmental constraints, I did not use a second cloud data source for the operation, but you can still see that the data source has changed, I hope that my example will help you with your question, if you have questions, feel free to contact me.

 

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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