Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

New column not getting loaded

I have an excel datasource.  A new column was added.  When I refresh the query it is not displaying the new column in Power BI.  I've tried everything so far on the forum.  Please help.

Need Help

2 Replies

  • TomasAndersson's avatar
    TomasAndersson
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi!
    Sounds like it's something within the query. Can you share what columns you have in Excel, your query steps (via Edit query) and what you see in the loaded table?

  • TomasAndersson's avatar
    TomasAndersson
    Icon for Solution Sage rankSolution Sage
    3 years ago

    The query only loads up until Columns29 in the Excel document. Could it be that the new column is an even later column? You could adjust the query manually in the advanced editor, work step by the step in the Applied Steps window.