Forum Discussion

Lcantemir's avatar
Lcantemir
New Member
8 years ago

Link between data base PBI table and a simple table

Hello,

 

I am working with a DB in PBI, the info is input from a matrix made by accountants, i want to link the DB to a new table(user friendly) one in the place of that matrix  and to make a link betweent the data.

 

Now the data base is completed manualy it means for every month 22 companies with 10 tasks means 220 new rows.

Could you help me find a method to streamiline this process?

 

 

The model of Data Base: 

 

 

 

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Lcantemir,

     

    Where are these records? If they are in a Excel workbook, you can connect to it in PBI Desktop. You will get the new data everytime you refresh the file. If they are in a DB, it's almost the same. You can import the data into PBI Desktop, then refresh to get the latest data.

     

    Best Regards!

    Dale