Power Query Warning sign but loading in Model OK

[057Sophie]

Hello,

I have a new semantic model, where I load two tables coming from a Dataflow GEN2.
The load of the tables is fine, 
Then I have referenced them to do some changes, the "removed columns" is working fine.
Then I did a column split as I am used to in other models:

Table.ExpandListColumn(Table.TransformColumns(#"Removed Columns", {{"Implemented By", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Implemented By")

Starting this step, I am not able to load any preview in power query, if I go the model and select "apply changes" the table is loaded to the model without any issue.

If I go back to the power query editor, and add some steps via the advanced editor to this table, the transformation are done without error by "apply changes" in the model.

How can I solve the fact that I can't load the preview of this table? (issue on ECO Tracker table below, Dim Relation Key Table is referenced frm ECO Tracker and loaded with any issue to the model too...) Of course I tried to empty my data cache but without any success. This same step on the same table in another report is done without issues and shown as preview in this other report

Edit: if I remove the Table.ExpandListColumn() from the formula bar then it is loading again:

But this shouldn't be such an issue as I have 4600 rows in the DF Table and by splitting in rows I should get 6000 rows, not that big

And the next step "Expand to New Rows" as = Table.ExpandListColumn(#"Split Column by Delimiter", "Implemented By") is again not going forward

[057Sophie · Accepted solution]

Strange, I think it is some global performance issue, I added a table.buffer step before referencing to the second table (ECO Tracker one) and it is loading now

[v-saisrao-msft]

Hi @057Sophie,

Thank you for reaching out to the Microsoft Community forum.

It's great to hear that your query is now loading. We greatly appreciate your efforts and thank you for providing the update on the issue. Could you please confirm if the issue has been resolved? Feel free to contact us if you have any further questions.

Thankyou.