Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
Please view the two screen-shots below.
I am trying to keep the column shown in the top screen but lose it when I convert to table.
Any assistance will be appreciated.
Thanks, Mark.
Solved! Go to Solution.
Please check out this file: https://www.dropbox.com/s/bram6131s01nv1t/PBI_ExpandJson.pbix?dl=0
You need to edit the query "Download" with a reference to your local drive
You just have to decide whether to join the tables in the query-editor, which would create one big monster-table, or create a data model, which would be the more professional approach.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @sunildatalytyx ,
if the fields are not included in the first 1000 items of the expanded content, then they will not show up.
In that case you have to add them to the M-code manually.
Imagine the automatic expansion had just found "PRN", then you'd add SNR like shown below:
Simply add them to the list with commas as separators.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @sunildatalytyx ,
if the fields are not included in the first 1000 items of the expanded content, then they will not show up.
In that case you have to add them to the M-code manually.
Imagine the automatic expansion had just found "PRN", then you'd add SNR like shown below:
Simply add them to the list with commas as separators.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Thank you Imke, thank you for the response, appreciate it. I've realised over time the below response and added the fields manually. Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |