Full column name not showing in table

[capson]

Hello, very new to Power Query, I am using excel 2016

Here is what I have.

The actual column names is:
HSD Models and Methods you would love to practice more with the support of a "method mentor" from the network

Only part of the Column name is showing in the table
HSD Models and Methods you would love to practice more with the support of a "me

I'm not sure if the issue is the quotes around "method mentor" in the column name or if the column name is to long?

also at the last step #"TextCombined2" I get the error:

Expression.Error: The column 'HSD Models and Methods you would love to practice more with the support of a "method mentor" from the network' of the table wasn't found.
Details:
HSD Models and Methods you would love to practice more with the support of a "method mentor" from the network

I would greatly appreciate any help with these two issues

Thanks you in-advance for any help

Here is the Query:

[COLOR=#000000][FONT='inherit']    let
        Source = Json.Document(Web.Contents("MyLink")),
        elements = Source[elements],
        #"Converted to Table" = Table.FromList(elements, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
        #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Sticky Issue", "HSD Models and   Methods you would love to practice more with the support of a ""method mentor"" from the network"}),
        #"TextCombined1" = Table.TransformColumns(#"Expanded Column1", {{"Sticky Issue", each if _ is list then Text.Combine(_,"|") else _, type text}}),
        #"TextCombined2" = Table.TransformColumns(#"TextCombined1", {{"HSD Models and Methods you would love to practice more with the support of a ""method mentor"" from the network", each if _ is list then Text.Combine(_,"|") else _, type text}})

    in
        TextCombined2[/FONT][/COLOR]

 

[Norie]

Is 'HSD Methods....' actually being treated as a column/field name?

 

[capson]

Hello Norie, Yes

 

[capson]

I found a thread on another forum about a similar issue but I do not now what to do with it

I am hoping someone here might

Hi,I have a JSON file with a variable text field whose length can exceed 2000 characters. When I import the file into PowerBI, the text field is truncated to 1023 characters.

How can I avoid this problem?

Hi,I found a solution to my problem.
Change the import query:
- add a change of type on the column (change from non-determined to text)

After this adjustment, the column is no longer truncated

http://community.powerbi.com/t5/Des...n-importing-data-from-a-JSON-file/td-p/206626

Thanks