Forum Discussion

inaryboy's avatar
inaryboy
New Member
8 years ago
Solved

Incorrect Data being pulled from Excel Spreedsheet in OneDrive

Hi,   I am seeing incorrect data in the BI Report.  I updated a field in Excel to 500 but it is not being updated in the report.  I tried deleting everything including the report the spreadsheet an...
Reports
  • inaryboy's avatar
    inaryboy
    8 years ago

    Hi Qiuyun Yu,

     

    Thank you for your reply.

     

    I found the problem.  Power BI was using COUNT as the default grouping method, in Excel when I use the same table it defaults to SUM.

     

    The data look good now.

     

    Thank you and appreciate your time.

     

    Regards,

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi inaryboy,

 

Glad to hear the issue is gone now :smileyhappy:.

 

As the data is fine now, I will close this thread. 

 

Best Regards,
Qiuyun Yu