Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Add additional data in excel file

I'm new to Power Bi, but was able to develop a report in PowerBi Desktop using data from Excel File saved in OneDrive. However, after completing the report, I realized that I added one new extra columns in my Excel file. I'm now trying to update my data in PowerBI after adding the columns in the original Excel file, but I can't see the columns. I did refersh as well but still it is not showing in the report data? Could anyone please help me, thanks

PBI Report

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Check your Power Query steps for any "Removed other Columns"  step where you may have used Table.SelectColumns.  While that is generally recommended it does have the effect that newly added columns in your source are not picked up in Power BI.