Best practice for importing SQL data to PBI

luckygirl Well, some of this depends on your skill level and what is the desired skill level of maintaining the solution. "Best practice" is generally to move the transformation of data as close to the source as possible. That would generally mean SQL views that perform the table joins. However, you could also do the transformations in Power Query and that would generally lower the skill level required to maintain the solution. There are a lot of analysts that can navigate around the Power Query Editor interface but aren't necessarily skilled at SQL.