Forum Discussion
Query Folding/ Native Query is not folding in Power Query
I am using my database (mysql) for powerbi (not using any query for integration) but eveything in my database is in text, now when i am chaning datatype in power query, native query is not supporting...
If transformations are not folding and you would still prefer to execute them on the database server rather than in the Power Query engine, then you can put the native SQL query code into Power Query instead. The input field is in the Advanced options of the MySQL connector: