Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NoelGrieve
Frequent Visitor

Service returns incorrect result compared to when published

Hi there PowerBI community!

At the end of each month I need to report on month end numbers.

The one source is from SQL which contains underlying data, I simply do a count of the rows, the other is a xls file which is on Sharepoint that simply contains the overall number and the date (no underlying data)

I have set it up so the xls file appends to the SQL query in the Desktop. When I refresh and publish to the service the numbers are correct. Problem comes in when I refresh the model in service. The service returns a different number

Example Instead of 14269 I get 99883.

All three queries are setup as dataflows (XLS, SQL and a Date Table)

I was thinking this may be date related so I have tried changing the date type both Using localle... and Default

Also for the XLS file using a direct query in the model to Sharepoint rather than a BI dataflow but unfortunately also not giving me the correct result. 

 

Any more suggestions of what to look for would be appreciated as I have been trying to resolve for the past three days.

 
BI Error.png
 
1 ACCEPTED SOLUTION

Hi @NoelGrieve

 

I am sorry for the issue you are experiencing.

Please create a support ticket for assistance.

v-xulin-mstf_0-1617070421905.gif

 

 

Best Regards,

Link

View solution in original post

5 REPLIES 5
v-xulin-mstf
Community Support
Community Support

Hi @NoelGrieve,

 

You can drag the same fields into visual and check.

Maybe some filters affect the outcome.

 

Best Regards,

Link

same visual no filters, when I refresh and publish from desktop, I get the correct result. when I refresh via service the number changes to be incorrect.

Hi @NoelGrieve

 

I am sorry for the issue you are experiencing.

Please create a support ticket for assistance.

v-xulin-mstf_0-1617070421905.gif

 

 

Best Regards,

Link

lbendlin
Super User
Super User

A couple of things don't sound right here. Power BI service cannot handle .xls files. Did you mean .xlsx ?

What's your reasoning for using dataflows?

yes correct, xlsx file. using dataflows or power query online as this means the query is decoupled from a specific dataset and can therefore be re-used.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.