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

Analyze in Excel - report data not matching web

One of the models I have developed in powerbi desktop does not work with "Analyze in Excel"  The excel workbook reports different results than are on the .com site.  Some measures have different values and some do not have any values in excel.  I've double checked that I'm using the same filters, same measures. Any suggestions on how to debug this?

1 ACCEPTED SOLUTION

If it were me, I  would start either at the top or bottom and work down/up introducing new filters until something is different. Eg

 

create a matrix and simply add "total sales".  Do the same in Analyze in Excel with a pivot. Of course the number should be the same. Then add year, territory etc one at a time until you find out what is different. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

3 REPLIES 3
trebgatte
MVP

You might also want to download the latest Analyze in Excel Updates from PowerBI.com. I had some issues resolved by updating. It should prompt you automatically. At the very least, it removes a potential variable from your issue.

 

Treb Gatte, Power BI Red Carpet Partner | Microsoft MVP | Twitter | Blog | Blog 2

If it were me, I  would start either at the top or bottom and work down/up introducing new filters until something is different. Eg

 

create a matrix and simply add "total sales".  Do the same in Analyze in Excel with a pivot. Of course the number should be the same. Then add year, territory etc one at a time until you find out what is different. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Greg_Deckler
Super User IV
Super User IV

Not without some sample data to play around with and try to replicate the problem.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors