Forum Discussion

knmath01's avatar
knmath01
Icon for Advocate I rankAdvocate I
3 years ago

PBI 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 ...
Need Help
knmath01's avatar
knmath01
Icon for Advocate I rankAdvocate I
3 years ago

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's avatar
knmath01
Icon for Advocate I rankAdvocate I
3 years ago

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's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
    knmath01
    Icon for Advocate I rankAdvocate I
    3 years ago

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

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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?