Field Type Amendment

[Ormie]

Morning,

If I amend a field format in the source Excel document, will Power BI be able to refresh the data without errors?

Basically I've got a data download from another system and the financial values were stored as text and I need to change them to decimal for a SUM but query editor can't do it so I was going to amend the data source.

Thanks,

Chris

 

[pjmorris]

Powerquery can and regularly does convert numbers stored as text to number. I created a short list of numbers formatted as text, '345 for example, and on import to PQ it automatically converted it to a number?

 

[Ormie]

Hi Peter,

Thanks for your comments, as is always the case with technology, I went back in and it worked fine

Chris

 

[pjmorris]

I think computers know how much we know - if we know only a little they play with our minds (and generally mess up)!! (or am I getting paranoid )

Glad its working.