Forum Discussion
Advocate IPBI Desktop to Service not matching data
Community ChampionThe data in the 2nd query is what is important. It is the #2 at the bottom. That will have the numbers.
However, if you have published to another workspace and it works, then I am 100% sure that either the data in the original workspace isn't refreshed or you have a filter/slicer setting that affecting it.
Advocate IOk I see that part and I looked at number two and compared them and still the same, chunk of dates are missing from when I ran the query from the XMLA in the service vs when I run it from the desktop version everything is there.
Here is where I have refreshed.
I have published and manually refreshed several times time on the below dataset
And then while viewing the report I refreshed using the highlighted
When I hover over the filter of that matrix, there are two filters it shows and they are the same for both and I don't see any hidden filters. What else I could be missing to look at?
- knmath01
When I logged in this morning, the one I published to the other workspace refreshed over night and now looks like the one with the missing data, both now still not matching what was published to the workspaces.