Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @Anonymous ,
please try to import the AO_54307E_ORGANIZATION table and append the tables.
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
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?
Any help, any suggestion?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.