PBI Desktop to Service not matching data

[knmath01]

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?**

[edhans]

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.

[SHK]

Hi, 

This surprisingly simple tip actually worked.  😊
Thx a lot.

[knmath01]

@edhans 

Thanks! I just double checked and the filters are the same between the service and desktop and I don't have any hidden filters currently. I reset all bookmarks as well and still the information is not the same.

[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?

[knmath01]

I'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. 

[edhans]

The 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.

[knmath01]

It's not through a gateway, our data source is hosted in a cloud based service. 

[edhans]

Can you download the PBIX file from the service, then use DAX Studio to query the data in that PBIX vs your local copy and see what is different?