Better to calculate a lookup or create a database view

[Anonymous]

More of a general question, but it will apply many times to the reports I am building with this dataset.  Data is coming from a MySQL server where I am able to create views.

The players table contains data like this:

player_id	player_name	org_id
1	Jennifer Smith	1
2	Adrian Wells	2

The org table contains data like this:

org_id	org_name
1	Blue Team
2	Red Team

I want to be able to slice player data by org_name.  Even when I set the relationships, I can't seem to create a slicer that shows org_name.  

My questions:  First, am I missing something that would allow me to create this slicer without either adding a new column in Power BI or creating a view with this data at the source?  Second, for a largish data set (~750k rows), am I better off adding a calculated column showing org_name in the players table or creating a view in the database that I import into Power BI?

[Greg_Deckler · Accepted solution]

For the last question, almost always better to create a view in the database versus add processing to desktop side.

For first issue, your relationship should be:

Org Table 1 -> * Players Table

On [org_id] columns. Then you should be able to slice by org_name from Org table.