Forum Discussion
Advocate IPBI Desktop to Service not matching data
Advocate II'm not sure if this was right but here is what I did. I opened the performance analyzer, refreshed the visual, and then copied the DAX info
And then I openend DAX Studio and ran the query against the XMLA endpoint for report and got the following, I don't understand the output?
I was't sure if you saw I did update my original message in that I tried publishing my model to another workspace and the information is matching desktop when published to that workspace but still not the other and I had no idea what could be the difference between the two workspaces that would cause this?
Both are a Premium Capacity workspace.
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.
- knmath01
Ok 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.
- edhans
What is the datasource? Is this going through a Gateway? Is the gateway up to date? New Power BI code can cause older gateways to fail or report incorrect data.