Forum Discussion
best practice for Data Model (connecting tables)
Hi, Last months I was creating my first PowerBI report which is working, but I would like to improve the data model/flow for which I need some advice. The report is basically showing an overv...
Hello Anonymous ,
You need to have a code in the sap data that reference that this transaction for this project so you could match the data with each project, or else how would you know that this data is for this project. so you need to have a foreign key to do a relationship.
And like generally, the best for data modeling is the star schema model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍