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

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.

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