Forum Discussion

anf1sher's avatar
anf1sher
Frequent Visitor
10 years ago

New column in source table not appearing in dataset after refresh

I have a great Power BI dashboard I've been using for a few weeks. The dataset is from an Excel doc hosted on OneDrive. I recently added a new column to the Excel spreadsheet but it never shows up in my dataset in Power BI. I created everything via the web interface and did not use Power BI desktop. Any ideas on how to get the new column to show up?

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Haven't had that specific issue in the Service but I have had the issue in Desktop before when I have customized my data model with custom columns. But, since you can't do that in the Service, hmmm. Probably don't want to recreate everything. You might try clicking the smiley icon in the Service in the upper right and explaining your situation to support. They might be able to give you a reason why things are not coming in. Do you get an error on data refresh?

  • fbrossard's avatar
    fbrossard
    Icon for Kudo Commander rankKudo Commander
    10 years ago

    Working with Excel is not a live connection on it.

    One the dataset have been created the metada have been stored on your service. If you wanna add column in your Excel source file and propagate it to your dataset, you have to reimport it to refresh the data model.

  • fbrossard's avatar
    fbrossard
    Icon for Kudo Commander rankKudo Commander
    10 years ago

    Working with Excel in PowerBI doesn't a live connection on it.

    Once the dataset have been created the metada have been stored on your service. If you wanna add column in your Excel source file and propagate it to your dataset, you have to reimport it to refresh the data model.