Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Let me first put that I am using v.14 of the Power Bi API as v.15 incorrectly imports dates (1 day behind) from SP Lists and this is the only way I have been able to fix my issue.
Anyway, I have 2 imported columns within Bi that are showing as "Table" type... and these contain, either 0, 1 or multiple values.
and when I try to expend the table values, it creates multiple rows (1 value per row), but need the values all in one row. API V.15 inports these columns as "Lists" and have the option to expand as either values or new rows which would be perfect, but as mentioned above, API 14, doesnt.
API v.14
API v.15
How can I get the table vlaues all in one row cell? If I have to go the multiple row route, is there then a way to concat the values into one row? Hope that makes sense and thanks in advance.
Use Text.Combine on the Value column of your table.