Changes in Database Columns

[srennie]

This month I came to update on of my Power BI reports, however, I discovered some of the columns in the database where I download the data from have changed. All the columns I use to build the report are still there but some additional ones have been added and removed so my report won't refresh.

I get the error 'We couldn't convert to Number'.

Can anyone point me in the right direct of how I can fix this problem within Power BI before I have to spend time rebuilding my whole report. 

Please note: I have no control over database changes and no way of communicating with the person who has made the changes. I can just download the data. 

[amitchandak · Accepted solution]

@srennie , Open the power query and check the steps, You should see the error after the first change type. Ast the first type change, correct the data type to filter data before this step or clean and trim 

[srennie]

@amitchandak - amazing! thank you - that was much simplier than I expected.