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

KierenPorter's avatar
KierenPorter
Frequent Visitor
1 year ago

3 impatient bumps would get you told off by mods on any other forum - so not sure why community support are getting away with it here?

 

I am also curious how someone else can accept a solution on the behalf of an OP?

 

I am grateful for Kees' contribution, but still waiting in hope for more insight by others - and do not recognise the solution accepted.

 

PS: what kind of calendar format is that?!?