Forum Discussion

HarrisonBi's avatar
HarrisonBi
Frequent Visitor
5 years ago
Solved

Best practice for importing data from multiple databases

Hey guys,   I am looking to understand the best practices for data modelling for my Power Bi report. In my situation, we have 3 databases from the same ERP system but are differentiated by geo regi...
Need Help
  • samdthompson's avatar
    samdthompson
    5 years ago

    Hello, your understanding is bang on. Thats the way to do it:

     

    1. Import the tables.

    2. For each Table add the custom column: Add Column >> Custom >> [NewColumnName]"Region Name" Custom column Formula ="Name you are needing"

    3. Home >> Append Queries >> Append queries as new >> Three or more tables. Select all the tables you want to add to the append, click add and click ok.

     

     

HarrisonBi's avatar
HarrisonBi
Frequent Visitor
5 years ago

Thanks for your reply.

Does this mean that data is stored twice? Once, in the source table and once in the appended table?