Forum Discussion
Solved
New to Power BI - Creating Tables
Hi all,
Looking for some advice for someone relatively new working with PBI. I have some data coming from a database and have a column with categorical data, i.e. "Apple", "Banana", "Broccoli". If I wanted to create a new grouping for this data based on this data, what would best pratice, a seperate reference table help offline or a table stored in Power BI which i can link the data to?
| Data Field | Reference Grouping |
| Apple | Fruit |
| Banana | Fruit |
| Broccoli | Vegetable |
| Grape | Fruit |
- If your grouping is frequently changing or needs to be managed by others, go with the reference table (option 1).
- If your grouping is static or has very few changes, you can manage it directly in Power BI with an internal table (option 2).
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
1 Reply
- If your grouping is frequently changing or needs to be managed by others, go with the reference table (option 1).
- If your grouping is static or has very few changes, you can manage it directly in Power BI with an internal table (option 2).
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn