Forum Discussion

PBI__User's avatar
PBI__User
Frequent Visitor
3 years ago

All Columns are not getting selected from a table until Preview is refreshed

Hi All, I’m getting a "missing column" error when i try to refresh a PBIX as the navigation step is not loading all the columns from a table during the initial refresh, due to which the later transf...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

PBI__User Hard to know specifically, sounds like a transformation drops the column but the column is referenced in a later step. Can you post the M code from Advanced Editor and name the offending column?

PBI__User's avatar
PBI__User
Frequent Visitor
3 years ago

Hi Greg_Deckler ,

 

Thanks for the response. Given below the steps in my power query. Could you please take a look?

1) Main query fetches all the tables in the selected schema (server details and schema name is passed as a parameter in this query)

2) All other queries/tables use the main query as source.

When I refresh, I get an error "The column Rank1 of the table was not found" as the rename step is referencing this column name. When I checked the previous step "DataTable" I couldn't see the column Rank1 in the result set though this column exists in the backend table. When I refresh preview "Rank1" column gets loaded and the missing column error disappears. This issue is not always on the same table, but occurs on different tables each time I refresh.

 

 

Thanks in advance,