Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add new MySQL table to Jira GetIssues template through Advance Query Editor

Hi,

I am trying to add a new column from a MySQL database AO_54307E_ORGANIZATION table

to the Jira GetIssues template.

 

This is the table that I want to import

 

From the table, I need the ID and NAME are crucial for the report.

 

 

Please find below the code from the query advance editor in Power BI desktop

 

 

I added the AO_54307E_ORGANIZATION on the fields line (3rd line in the advanced query editor). I tried to added lines at the end of the script but it never works.

Could you please let me know what code should need to be added to get the information from the AO_54307E_ORGANIZATION table?

Many thanks

Need Help

4 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    please try to import the  AO_54307E_ORGANIZATION table and append the tables.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

       

      I added AO_54307E_ORGANIZATION to the field lines ,"AO_54307E_ORGANIZATION"}, and ,"AO_54307E_ORGANIZATION"},

       

      I also append the table as you suggested but there isn't any data in the column.

       

      I think more lines need to be added in the query editor, like 

      #"Expanded AO_54307E_ORGANIZATION" = Table.ExpandRecordColumn(#xxxxx "AO_54307E_ORGANIZATION", {"ID","NAME"}, {"AO_54307E_ORGANIZATION.ID","AO_54307E_ORGANIZATION.NAME"}),

       

      Thanks in advance 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I added this line to the query advanced editor:

         

        #"Expanded AO_54307E_ORGANIZATION" = Table.ExpandRecordColumn(#"Filtered Rows1", "AO_54307E_ORGANIZATION", {"id", "lower_name", "name", "search_name"}, {"AO_54307E_ORGANIZATION.id", "AO_54307E_ORGANIZATION.lower_name", "AO_54307E_ORGANIZATION.name", "AO_54307E_ORGANIZATION.search_name"})

        in
        #"Expanded AO_54307E_ORGANIZATION"

         

        I added all the columns from the database to verify if Power BI was getting any data. Unfortunately, all the columns are empty (Null value)

        I have a feeling that Power BI doesn't get any data from the table...

        Can anyone confirm that? 

        Is there something missing?

        What is the correct method to import the data?