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

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.

 

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

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

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

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

        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.