Forum Discussion
Advocate IPBI Desktop to Service not matching data
Hi all!
Today a user reached out to me and said that the Spend information was missing from their report I created. This was created about a year ago or so and this was working fine as of Friday and there have been no updates made to the model or the visuals. The datasets refresh every night and there were no errors and I don't see any other issues with reports connected to this data set.
This is what the matrix looks like in the desktop:
This is what it looks like when I open it in the service:
What I have done to attempt to resolve is refresh the model from desktop and the service, republish the model to the service, refresh the visuals, reset all filters and clear the cache. I'm not sure what else to do to resolve or where the disconnect is between the two? There is no row level security.
**To add to this, I just published the model to a different workspace and it's showing the data as it should. What can I compare between the two workspaces to figure out what is causing this issue?**
11 Replies
- edhans
Community Champion
Filters and slicer selections are persistent between sessions, regardless of republishing the data. I would look at those. Hover over the Filter icon in the service and see what is filtering that data. On the desktop it is the old funnel icon.
That still might not tell the whole story as hidden filters do not show up when you hover over it - they are hidden but still affect it.
Also reset all bookmarks to default - and this will also reset filters using the clockwise circle arrow in the upper right.
This will ensure everything is back to the default of the published report.
- edhans
Well, it is difficult to know what else is going on, but I assure you, this is not a bug.
Is this in a premium workspace (PPU or Premium Capacity?) - if so, in Power BI Desktop, get the query for the Matrix viz from the Performance Analyzer, then run that query in DAX Studio against the XMLA endpoint for that report. What does it return?
