Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
So i have a exported data from azure blob to power bi. The files are in json format. When i parse the json file all columns get expanded. In this expanded column i have one more column which is in json format. I cannt parse this column as json as half the values in the columns are shown as record and half as text.
If anybody knows the solution or have solved this kind of issue please let me know
Thank you
Regards,
Rushank Patil
Solved! Go to Solution.
HI all,
I foudn the solution
Hi @Anonymous ,
You could filter out the text and then expand them.
For example, below is the a column with text and record.
Untick all the text and click OK.
Expand it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-stephen-msft ,
I dont get the option to filter out as seen in screenshot ( i have even clicked on load more option but nothing comes up)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |