Power BI is founded on the idea of self-service BI and Excel is the most common data source in the world. While Power BI can import that information with ease, the data may not be in the best format. In this episode, we discuss areas report creators should consider when building Power BI reports so their reports can perform to their satisfaction and maintenance of the reports will be easier over the long run.
The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/03/episode-205-data-modeling-for-power-bi. Have fun on the SQL Trail!