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

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

SandySharma's avatar
SandySharma
Resolver I
9 years ago

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'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.