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 import an XML file and all columns can be expanded in the UI. However, one of the columns contains both text and table types that I can't see a data drill button. I've tried any methods I can find but it didn't work.
Are there any other ways to solve this?
Thanks
@z22741
If you filter only table and try, it should work. Since the column has mixed data types, the expand option isn't active.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for getting me back. I actually need the data inside the table. Do you happen to know how to do that?
@z22741
I recreated your scenario and managed to expand the table after removing non-table rows. check the steps after Converted to the Table in the attached file
You can download the file: HERE
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Sorry I didn't have my question clear. I'd love to keep all data together. For example, the end result should have row 3, 5 in figure 1 + figure 2 all the data.
If this' the data I have
and this will be if I clicked the table and what the data looks like. Only a list of data
@z22741
Not quite clear about what exactly is needed, can you provide an example?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The table I have
Id | Book |
1 | Table |
2 | 123456 |
3 | 789101 |
If you click Table, it's a list of Book Id also
Book.Value |
abc123 |
def124 |
ghj125 |
The end result I expect is
Id | Book |
1 | abc123 |
1 | def124 |
1 | ghj125 |
2 | 123456 |
3 | 789101 |
Since I can't find an expand button, I don't know how to get all the data inside of the table
@z22741
Check the steps in the attached file and adjust as per your table. Your tables should look as per Start step.
You can download the file: HERE
Your initial table was this:
After Transformation:
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy Thanks for all the helps you offered so far!
Don't know why it doesn't work for me. It gave me null for all the rows I expanded.
Below is the data have and when I click Table it showed "Element: Text". Not sure if that's why it won't work?
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |