Query Folding Details for Power BI

Hi Sudip_J ,
Thanks for reaching out to the Microsoft fabric community forum.

Here are the links to assist you in understanding and implementing query folding in Power BI when connecting to SQL Server and MySQL data sources:

1. Query Folding Basics 

• https://learn.microsoft.com/en-us/power-query/query-folding-basics

• Provides an overview of query folding, its benefits, and how Power Query translates steps into native queries.

2. Power Query M Language Specification

• https://learn.microsoft.com/en-us/powerquery-m/power-query-m-language-specification

• Offers detailed information on the M language used in Power Query for data transformations.

3. Connect to MySQL Database from Power Query Desktop

• https://learn.microsoft.com/en-us/power-query/connectors/mysql-database

• Step-by-step guide on connecting Power BI to a MySQL database using Power Query.(learn.microsoft.com)

4. Connect to SQL Server Database from Power Query Desktop

• https://learn.microsoft.com/en-us/power-query/connectors/sql-server

• Instructions on establishing a connection between Power BI and SQL Server databases.

5. Power Query Documentation Hub

• https://learn.microsoft.com/en-us/power-query/

• Central hub for all Power Query documentation, including connectors, transformations, and performance optimization.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Sreeteja.
Community Support Team