Forum Discussion

KierenPorter's avatar
KierenPorter
Frequent Visitor
1 year ago
Solved

Errors when referencing SQL source in subsequent queries

Hi everyone!   Until recently I've only used Excel and .csv datasources for my .pbix work - and have typically followed the convention: Query1 = get & do some general cleaning of the source data (...
Need Help
  • PwerQueryKees's avatar
    PwerQueryKees
    1 year ago

    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

v-prasare's avatar
v-prasare
Community Support
1 year ago

KierenPorter, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query