Values being replaced by zero when importing data

[EBB286]

Hello,

I am hoping someone might be able to help me with an issue that is driving me a little bit crazy.

I have created a dashboard (which took me a lot of time) and it all seemed to work fine but I have now noticed that some of the values in the excel file I am connected to are being replaced by zeroes.

The Excel file (saved as .xlsx) has values associated with Property in different columns.

But when I look at the data in the Power Query Editor they show up as zeroes.

There are several columns holding data related to Property and they all show up with zeroes.

I tried renaming the columns in the source file and amending the text in the Advanced Editor but that did not work. I have also tried to create a completely new report to import the data again and start afresh. The data is in exactly the same format and it now pulls through the Property values just fine, but replaces all the values in columns covering Emerging Markets with zeroes.

Can anyone tell me what is causing this error with importing?

All the best,

Edward

[EBB286 · Accepted solution]

Never mind, ignore me!

I had made some changes in Power Query so I went back through the staps, removed all I could and now it is working perfectly!