Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
maasool
Helper I
Helper I

We cannot convert the value "008" to type Table

Hi!

Can anyone suggest how to solve this problem?

I expanded column, which contained "Table"s and it generated this result at the end.

 

maasool_0-1660806572921.png

 



Best regards

1 ACCEPTED SOLUTION
4 REPLIES 4
maasool
Helper I
Helper I
wdx223_Daniel
Super User
Super User

before using the function of Table.ExpandTableColumn, to make sure all the values of this column is table.

Hi! Thanks, I now understand the problem and your proposed solution. However, I am not sure how to implement this. Could you be more precise how should I use the function?

I think I managed to add this function, but now I have a new error:

maasool_0-1660813959746.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors