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.
Hello
i'm struggeling with one problem for some time 🙂
I get supplier xml and in some fields there are multiple urls, but when importing with power query it doesent recognize this filed as multiple items in one field and show only Table value instead actual urls
here is how it looks in xml: PowerQuery
link to picture when edit in PowerQuery: edit power query
thanks for any advice
Martin
First thank you for your help.
Inside this column there are additional picture urls. Sometimes you have one additional picture, sometimes none and sometimes two or more and this last combination is problematic.
This is how it looks in PQ and the code that expands data in column
= Table.ExpandTableColumn(#"Razširjeni TOWARY.PRODUKT.KOLORY.KOLOR", "TOWARY.PRODUKT.KOLORY.KOLOR.zdjecia", {"zdjecie"}, {"TOWARY.PRODUKT.KOLORY.KOLOR.zdjecia.zdjecie"})
and inside xml when open it in web browser
HERE you can also get actual XML
Hi @malcek
The XML must be in a format that is turned into a table in PQ. What exactly do you want to do? Extract the contents of these tables? What data is inside the tables?
Without seeing your real data it's harder to find a solution but i think I'd probably duplicate your query, remove allrows that don't have a Table, then expand all the tables and extact th data you need.
You can then append this data (from the duplicated query) back onto the original query.
Please supply your PBIX file or more help.
regards
Phil
Proud to be a Super User!
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 |
---|---|
117 | |
101 | |
69 | |
69 | |
43 |
User | Count |
---|---|
146 | |
106 | |
105 | |
90 | |
65 |