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 all,
I hope you are able to help me.
I have got one big folder and in this folder I get two different data types - CSV and JSON.
I build up my data tables for CSV and JSON.
CSV table format
a_serialnumber | a_value_1 | a_value_2 | ... | a_value_n
JSON table format
b_serialnumber | b_value_1 | b_value_2 | ... | b_value_n
For the Line chart I need one table. What I like to do now, is to add the JSON table under the CSV table to get one big table and data source like
serialnumber | value_1 | value_2 | ... | value_n
Does anybody have an idea how to do that?
BR
Timo
Solved! Go to Solution.
Hi @Anonymous,
For your case, you should keep the name of the column headers to be the same for the two tables, then you could use Append queries.
If you still need help, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
No one an idea?
Hi @Anonymous,
For your case, you should keep the name of the column headers to be the same for the two tables, then you could use Append queries.
If you still need help, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
You can use the Append Queries feature, or Table.Combine function if you know M
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
@Anonymous Please try below steps:
Step1 : Convert your JSON format file into Table structure in "Power Query" after importing your JSON file.
Step2: Then expand the table with all the fields as required.
Now you have JSON file in table structure as below
Then you can use "Append Queries" to append both JSON file and Table into single final result which can be used further.
Proud to be a PBI Community Champion
Hi,
thanks for the fast reply.
If I use "Append Queries" I got this (arrows show my prefer solution).
BR
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.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |