Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Column of table not found

Hello everbody,   I want to transform the data below into 3 seperate lines (now it is one cell with three lines)    with this code   let Source = Excel.Workbook(File.Contents(myPath"...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    I use the same code, but I have no problem.

    Please make sure your column name is consistent with the name in the code.

    Please check out your applied steps in the Power Query. I renamed the column in my table.

    So, when I still use ‘Source’ as data source, it has the same issue as yours.

    Make sure you are using the latest data source.

    Best regards,

    Lucy Chen

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

I use the same code, but I have no problem.

Please make sure your column name is consistent with the name in the code.

Please check out your applied steps in the Power Query. I renamed the column in my table.

So, when I still use ‘Source’ as data source, it has the same issue as yours.

Make sure you are using the latest data source.

Best regards,

Lucy Chen

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