cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
inaryboy
New Member

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 and recreating it from scratch but the data is still incorrect.  It is like the data is either being cached or filtered.  When I right click on one of the bar graphs and select "See Records".  It shows the 500 value (see bottom image).

 

Is there something I am missing or is this a bug?

 

BIData.pngRecords.png

1 ACCEPTED SOLUTION
inaryboy
New Member

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,

 

 

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @inaryboy,

 

Glad to hear the issue is gone now Smiley Happy.

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
inaryboy
New Member

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,

 

 

View solution in original post

v-qiuyu-msft
Community Support
Community Support

Hi @inaryboy,

 

As the 500 displays in See Records, it means the dataset already updated. How do you find the 500 not updated in the report? 

 

Please enter Edit mode of the report, then add a table visual, drag the ActionName and NoOfMachines columns into the table visual. then sort the NoOfMachines column descending, to check if 500 is here. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors