Power Bi - duplicates table bw hana

[Anonymous]

Hello experts,
I've come across an issue where I've identified duplicate tables in different domains, such as Finance and Supply Chain. I know which domain each table should rightfully belong to. The challenge arises because these tables are linked to Power BI reports. My concern is how to proceed without causing disruptions. Let's say, for instance, I've found that the MARC table exists in both Finance and Supply Chain, but I've decided it should only be associated with Supply Chain. This decision could potentially break the reports connected to Finance. Is there a way to guide Power BI to automatically locate the correct path to the table, given that its name remains unchanged? Naturally, I would ensure that access rights to the Supply Chain domain are properly set up.

[v-huijiey-msft · Accepted solution]

Hi @Anonymous ,

Hope all is going well.

For the same data source, as long as the connection name and verification are the same, only one data source will be displayed. If the next referenced table is the same as the previous verification, there is actually only one data source.

Therefore, changes cannot be made through Change Data Source.

Alternatives are:

Create multiple dataflow, put the tables related to Finance in one dataflow, and put the tables related to Supply Chain such as MARC in another dataflow. Create a semantic model based on the dataflow, and then use the data to create reports.

For relevant documentation on dataflow, please refer to the link below:

Creating a dataflow - Power BI | Microsoft Learn

Configure and consume a dataflow - Power BI | Microsoft Learn

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[ray_aramburo]

You can manually rewrite the source using the Advanced Editor in Power Query (assuming they are both in the same database/source) or select the specific data location on the first step in the query by clicking the gear icon in Source. There you can select the new path. Your query won't break as long as this "new table" has the exact same structure as the previous one.