Link between data base PBI table and a simple table

[Lcantemir]

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: 

[v-jiascu-msft]

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