Problems refreshing Excel data saved on my pc

[Anonymous]

Hi,

Apologies as I'm new to Power BI/ data vis in general.

I created a simple model from a dataset that I've uploaded from my PC. I transformed the data slightly once I uploaded it. I then changed my source file by adding a few extra columns based on end user requirements. When I went to refresh I got an error message saying a particular Column wasn't found.

Any suggestions on how to resolve this? I have added/removed a couple of extra columns from within Power BI desktop but the error has occured when I added them to the source file.

Thanks in advance

[Anonymous · Accepted solution]

Hi @Anonymous 

Please correct me if I wrongly understood your question .

You create a dataset with local excel file , and then use the dataset to create a report in Desktop , right ? Then you change a column name in excel file and refresh report in Desktop , you got an error message, right ?

If your data source structure has changed, it cannot be refreshed directly on the report in Service. You need to find the pbix file related to the dataset, then refresh it on the Desktop, update the changed structure to the report, and then republish it to the Service. Finally, call the report of this dataset and refresh it on the Desktop .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Samarth_18]

Hi @Anonymous ,

Please make sure you have all the existing column with same name(case sesitive) in new file.

Thanks,

Samarth

[Anonymous]

Thanks Samarth for getting back to me. The problem is that I have to change the column headers in my source data set. When I made those changes and tried a refresh it produced an error. It's looking likely that I'll have to add additional columns to the dataset in future, is there a way that this can be done without getting the same errors?

Thanks