Forum Discussion

SandySharma's avatar
SandySharma
Resolver I
9 years ago
Solved

Power BI Desktop is not reading correct data from Excel

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 measu...
Need Help
  • SandySharma's avatar
    SandySharma
    9 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Any way to make a copy and anonymize the data?

SandySharma's avatar
SandySharma
Resolver I
9 years ago

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.