Forum Discussion
SandySharma
Resolver I
Resolver IPower 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...
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
Community Champion
Community ChampionNever seen that, would have to see the Excel file to troubleshoot.
SandySharmaResolver I
Resolver ICan Not share excel, as you can understand it is sensitive data. I tried the same with other tools but did not face the same.