Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Creating a template and managing a MySQL DB Name as a parameter

Hello everyone,   I want to create a power bi template that includes all the tables of a MySQL DB for one of my clients and save it as a template. All my clients have exactly the same tables and I ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,

    You can create a database name parameter in your PBIX file following the instructions in this blog, then add a new blank query and paste the code below to the Advanced Editor of the blank query.



    let
    Source = MySQL.Database("Server", ""&dbname&"", [ReturnSingleDatabase=true]),
    TTable = Source{[Schema=""&dbname&"",Item="TableName"]}[Data]
in
    TTable


    After that, create Power BI template following the guide in the blog below.

    https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I have found the solution. I will provide information shortly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous,

    You can create a database name parameter in your PBIX file following the instructions in this blog, then add a new blank query and paste the code below to the Advanced Editor of the blank query.



    let
    Source = MySQL.Database("Server", ""&dbname&"", [ReturnSingleDatabase=true]),
    TTable = Source{[Schema=""&dbname&"",Item="TableName"]}[Data]
in
    TTable


    After that, create Power BI template following the guide in the blog below.

    https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

    Regards,
    Lydia