Power BI Desktop is not reading correct data from Excel

[SandySharma]

HI Gurus,

I am new to Power BI and I observed that some times Power BI is not loading correct data from Excel file. I have an excel file which contains 50 measures out of these measures few measures value is loading as 0, I tried lots of things but could not figure out why this is happening. Is there any problem with Excel drive. I connected lots of excel but it is happening only with one Excel. but When I am using other tools to load the same data then it is working fine.

SQL is reading correct data, Tabeau is also reading correct data.

Please help me.

[Greg_Deckler]

Never seen that, would have to see the Excel file to troubleshoot.

[SandySharma]

Can Not share excel, as you can understand it is sensitive data. I tried the same with other tools but did not face the same.

[Greg_Deckler]

Any way to make a copy and anonymize the data?

[SandySharma · Accepted solution]

HI Gurus,

After dowing lots of hit and trail I found a way of fixing the way to read the correct data. 

Edit Query --> Advance Editor 

Checked the Query and found it was reading in int64.type format, I changed to type text and applied and reedit the same and chage the data type from Text to Percentage then it started reading correct data.

Thanks to all of you for putting your effort.