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
dkpcr5
Helper II
Helper II

Cannot convert to type List

I think my M needs a syntax adjustment, but I'm not sure where or how.

 

Here's the M:

let
Source = Json.Document(Web.Contents("https://apiURL/ACCOUNT_INFO?$top=2000",
    [Headers=
        [   
            #"ocp-apim-subscription-key" = Text.Combine({Subscription}),
            #"integrator-key" = Text.Combine({Integrator}),
            #"x-universal-refresh-token" = Text.Combine({Refresh}),
            #"x-universal-directive" = "x",
            #"respos-cache" = "false"
            ]]
        )
    ),
#"Converted to Table" = Record.ToTable(Source),
Value = #"Converted to Table"{0}[Value],
Custom1 = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(Custom1, "Column1",
    {"Account_ID", "Account_Title"}
    )
 
in

    #"Expanded Column1"

Here's the error:

 

Expression.Error: We cannot convert the value "https://host/$metada..." to type List.
Details:
Value=https://host/$metadata#ACCOUNT_INFO
Type=[Type]

 

When I'm told to "Go To Error," it seems the offending part is: 

Custom1 = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

 

Any assistance would be appreciated. Thanks!

1 ACCEPTED SOLUTION

Closing this thread since I've resolved the issue.

 

Turns out, the problem was not with the syntax of the M, but with the fact that the API wasn't returning any records due to session expiration. After renewing the session, the API once again returned data, and the error went away without any change to the original M.

 

Sincere kudos to @watkinnc for the assist.

View solution in original post

3 REPLIES 3
watkinnc
Super User
Super User

I would try replacing:

 

Value = #"Converted to Table"{0}[Value],

With:

 

NewValue = #"Converted to Table"[Value],

 And then your next line would be:

 

Table.FromList(NewValue,...etc


--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Thanks, but not sure I'm completely following. You're saying, just remove the {0}?

 

When I do, I get the results below:

cannotConvert.PNG

The error for cell 1 under "Account_UID" is shown in the image. 

The error for cell 2 under "Account_UID" is different, and says:

 

Expression.Error: We cannot convert a value of type List to type Record.
Details:
Value=[List]
Type=[Type]

Closing this thread since I've resolved the issue.

 

Turns out, the problem was not with the syntax of the M, but with the fact that the API wasn't returning any records due to session expiration. After renewing the session, the API once again returned data, and the error went away without any change to the original M.

 

Sincere kudos to @watkinnc for the assist.

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