Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power Bi - duplicates table bw hana

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. Th...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

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.