Forum Discussion

lisaeugene's avatar
lisaeugene
Frequent Visitor
8 years ago
Solved

One data column not refreshing, but not getting any error messages

My model has been pulling data from excel files that upload to a folder monthly. Never had any problems. That data flows into a table that merges with another table to form the query I use for modeli...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Check in the import queries that your column hasn't become lost somewhere. Given that you are using Excel files, its possible something has occured that has caused your column to become excluded.  Some examples might be:

     

    • One of your initial files is CSV and only looks for X columns but your column is a now X + 1
    • The column you care about has had a name change, even if its a blank character added, and is now being missed or excluded by a join or a remove other columns.
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Check in the import queries that your column hasn't become lost somewhere. Given that you are using Excel files, its possible something has occured that has caused your column to become excluded.  Some examples might be:

 

  • One of your initial files is CSV and only looks for X columns but your column is a now X + 1
  • The column you care about has had a name change, even if its a blank character added, and is now being missed or excluded by a join or a remove other columns.
  • lisaeugene's avatar
    lisaeugene
    Frequent Visitor
    8 years ago

    Your suggestion was correct. The column in question had a slight name change: one letter in the column name was written in lower case instead of its usual upper case. Once I corrected that single letter, saved the Excel file and refreshed the table in Power BI, all of the data from that column uploaded into the query perfectly. 

     

    Thank you!