Forum Discussion
Errors when referencing SQL source in subsequent queries
Can't help you with the MySQL connector and how it manages connections to MySQL.
Your way of working to avoid duplication by breaking up your queries is exactly what I am doing with CSV files of with the DataVerse connector without issues.
You could try a middle ground by creating parameters for the servername and database name. The most likely to change values in your query and the do the mysql.database() call for each individual table.
Did I answer your question? Then please (also) mark my post as a solution and make it easier to find for others having a similar problem.
Remember: You can mark multiple answers as a solution...
If I helped you, please click on the Thumbs Up to give Kudos.Kees Stolker
A big fan of Power Query and Excel
Can't help you with the MySQL connector and how it manages connections to MySQL.
Your way of working to avoid duplication by breaking up your queries is exactly what I am doing with CSV files of with the DataVerse connector without issues.
You could try a middle ground by creating parameters for the servername and database name. The most likely to change values in your query and the do the mysql.database() call for each individual table.
Did I answer your question? Then please (also) mark my post as a solution and make it easier to find for others having a similar problem.
Remember: You can mark multiple answers as a solution...
If I helped you, please click on the Thumbs Up to give Kudos.
Kees Stolker
A big fan of Power Query and Excel
no worries about the SQL, your input is welcomed! I am already using a "blank" query to hold single text values for those "hotswap" values, and had had in mind moving to using a parameter (for on-open prompts for when I make the .pbix a .pbit for use by others) - so its good to know I'm not alone in my thinking (t)here!
