cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RiccardoC Frequent Visitor
Frequent Visitor

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

mysql.PNG

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

GetIssues.PNG

 

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

4 REPLIES 4
Community Support Team
Community Support Team

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

Hi @RiccardoC ,

 

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

 

Capture.PNG

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
RiccardoC Frequent Visitor
Frequent Visitor

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

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.

54307E.PNG

 

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 

RiccardoC Frequent Visitor
Frequent Visitor

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

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)

null.PNG

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?

 

RiccardoC Frequent Visitor
Frequent Visitor

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

Any help, any suggestion? 

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,840)