Forum Discussion

P3Sven's avatar
P3Sven
Advocate I
3 years ago

Change Datesource in Power Query deletes Relations in Datamodel

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 ...
Need Help
DataInsights's avatar
DataInsights
Super User
3 years ago

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's avatar
P3Sven
Advocate I
3 years ago

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