Qirect Query Totals do not match

[Anonymous]

Hi all.

We published couple of reports using direct query from SAP BW. And I do not know why but we get couple of differencies in what we see on the desktop and what in PowerBI service (same report, same visuals).

Firstly, different Totals, can you advise why they're different in desktop and service ?

Secondly, on the desktop there is only one value and one company code and in service it displays same value for all company codes.... Do not get it , does anyone know where this all comes from ? Thanks

[Anonymous · Accepted solution]

Thank you for the answers but appeared that issue fixed itself, possibly was a bug 🙂

[collinq]

Hi @Anonymous ,

I have some options to think about.  On the first, with the different totals.  Are these both refreshed at the same time? Is it that you are looking at it in Desktop and then immediately publishing it and then looking at the data differences?  Are you using RLS?  It appears that you have both of these at the same level of drill down in the matrix but is there any difference between the two?  Do you have any filters turned on with either of these?  

The second question - different company codes.  I would refer you initially to all the questions above.  And then, this appears to be different in level of drill down and/or in your linking.  If it is linking, then that might also be the answer to the first question.  This makes me wonder if these two versions are not at all in sync.

[Anonymous]

Thank you, @collinq , but yes, the data is the most up to date both in desktop and in service (data is quite static), no RLS used, no filters, both ways it is expanded to the lowest hierarchy level. 

In regards to 2nd part - originally there is only 1 company code (A010) since others have no values. In the desktop I do not enable "Show when there is no data" but once publishing to service it not only displays all company codes with no data but for some reason takes the same value from the A010. 

[aj1973]

Hi @Anonymous 

Indeed it is weired, however DQ connection mode has some limitations(By the way the images you shared indicates that your desktop is in a Live connection mode), Please check out my Table of comparison if your report falls into one of theses limitations