Technical requirements
There is a combined sample file available for this chapter. All the sample references can be found in the Composite and Aggs.pbix
file, in the Chapter12
folder in this book's GitHub repository: https://github.com/PacktPublishing/Microsoft-Power-BI-Performance-Best-Practices. Since this example uses DirectQuery to access a SQL server database, we have included the AdventureWorksLT2016.bak
SQL backup. Please restore that database to a SQL server and update the connection in Power BI Desktop to run the sample successfully.