Extract list of records (from SharePoint survey)

[Idigorasu]

Hi,

I have some Sharepoint surveys and I have to analize the data using PowerBI.

Problem is, every answer is a List with Records inside.

I tried using the button next to each column name, but that just made the table expand exponentialy.

I don't know how to do this. Every other post about this only works with a single column, I have 10.

[dax]

Hi @Idigorasu m 

I am not clear about your data, if you want to expand the data, I think you could click button like below

If this is not waht you want, please correct me and explain it to me in details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idigorasu]

Hello Zoe, thank you for your help.

When I try to extract the values, it gives me an error.

Expression.Error: Unable to convert a value of type Record to type Text.
Details:
Value=
Answer=10
Question=Teacher 1
Type=[Type]

I guess it's because each Record has 2 values inside. A text and a number.