Change Datesource in Power Query deletes Relations in Datamodel

[P3Sven]

Hi lovely Community,

Short issue task description:

I wanna shift some heavy Power Queries to Dataflows. So I've copied Code 1:1 to Power Bi Dataflows, works fine.

Now I would like to change my original Datasource to new prepared Dataflow.

Old Way: Dataverse > Datamodel

New Datasource: Dataverse > Dataflows > Datamodel

Issue:

After loading to data model, all relations regarding my prepared table are gone. Although all Column Names / Types are the same..

Already tried:

- Disabling Auto Detect Relationships.

- Only replacing first lines of Power Query Code, not the last finish line

- Step by Step replace: First loading new Dataflow Source as new table, after replacing the old table with the Datasource code

- Referenced Power Query with new Dataflow as Datasource for old table as Datasource

Any ideas why all relations will be deleted with changing Data Source? Is it cause of Displaynames of Dataverse Connector? So changing the datasource will miss metadata?

Need to shift multiple Power Queries to Dataflow and don't want to build up datamodel again with all relations..

Thank you in advance!

BR,

Sven

[DataInsights]

@P3Sven,

You could try copying the relationships using Tabular Editor. This is a free tool that allows you to edit the tabular model.

1. Save the old pbix as a new pbix and replace the Power Query code with the dataflow code. The relationships will disappear.

2. While the new pbix is open, open the old pbix (both files should be open).

3. Open Tabular Editor (TE) within each pbix.

4. In TE-old, copy the relationships.

5. In TE-new, paste the relationships.

[P3Sven]

Hi @DataInsights ,

thank you! Its a nice workarround if we have a "changed" table and need to shift some relations to it.

But for me its not the "right" solution cause I've copied everything 1:1 and just have changed the data source. All columns, all data types the same and PBI deletes all relations. 

@v-xiaosun-msft:

Unfortunately its not a solution for me. Do you have an idea why everything will deleted by PBI although all columns are the same?

BR,

Sven