Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |