Training file for Wide World Importers

[KriZo]

Heya, 

Does anyone know about a pbit file for Wide World Importers database. 

I need it for internal training in Query optimization, specifically focusing on Query Folding. 
So ideally the file has some bad but realistic applied steps, that doesn't fold but where moving around, doing other stuff etc. would improve and make as much of the query fold. 

Does such a file exists? I tried using ChatGPT, but the applied steps it creates are just unrealistic, like changing Qty to Text in transactions table, doubt that would ever happen in a real life setting. 

___________________________________________________________________________________________________________________________

Did I solve your question? Mark my post as a solution! Kudos are appreciated as well as LinkedIn endorsements.

[v-heq-msft]

Hi @KriZo ,

Based on your description, the goal of query folding in the first place is to offload or push most of the work of query evaluation to a data source that can compute query transformations.
The query folding mechanism accomplishes this goal by converting the M script into a language that the data source can interpret and execute. It then pushes the evaluation to the data source and sends the results of that evaluation to Power Query.
So, in order to do more query folding, you can delegate as much of the processing to the data source as possible. If you can't collapse all the steps of a Power Query query, look for steps that prevent the query from collapsing. Whenever possible, advance subsequent steps in order to include them in query folding.
Meanwhile, with native SQL queries, you can use the Value.NativeQuery function to do this

Value.NativeQuery - PowerQuery M | Microsoft Learn

You can refer to these documents
The first is an introduction and optimization guide for query folding in Power Query

Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn

Then there are examples for the three query folding cases,It uses the Wide World Importers database you mentioned. 

Query folding examples in Power Query - Power Query | Microsoft Learn

Lastly, Query folding indicators.The query folding indicators feature is available only for Power Query Online.Look up the folding indicator to help you understand the steps for folding or not folding.

Query folding indicators in Power Query - Power Query | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[KriZo]

Thanks for the input @v-heq-msft 

But I am personally fully aware of what and how query folding works, i just need a file that's bad so i can train others, with examples. And I was thinking I could use Wide World Importers demo database, cause then we each can have a local installed demo, a bad pbit file and we can have some interactive training me and my coworkers.