3/31/2024 0 Comments Ms excel connect to mysqlIn the case of the poster’s question, this means that he just asked to bring 40 million records into Excel, rather than filtering them down on the server. Why is this an issue? Dynamic parameters use custom lines of code, which can’t be folder. This continues to occur until you hit a command that the database doesn’t know, at which point it returns the data to Power Query, and the rest is done in your instance of Excel. This means that the majority of the heavy lifting is done at the database, not your workstation. While this isn’t technically correct, you can look at query folding like this… As you connect to the database and start filtering and grouping via the user interface, Power Query passes these commands to the database to execute. Power Query is designed to take advantage of query folding when targeted against a database. There are a lot of reasons that you should NOT go this route. Someone asked a question in the forum on the topic, so that finally inspired me to write it up. ![]() One of the questions I get quite frequently is how we can pass parameters to SQL queries, allowing us to make them dynamic.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |