Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
knmath01
Advocate I
Advocate I

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 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:

knmath01_1-1679334921537.png

This is what it looks like when I open it in the service:

knmath01_3-1679335082415.png

 

 

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 11
edhans
Super User
Super User

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.

edhans_0-1679336155182.png

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.

edhans_1-1679336241686.png

This will ensure everything is back to the default of the published report.

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi, 

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


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

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?



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

 

knmath01_0-1679348935743.png

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?

 

knmath01_1-1679348992556.png

 

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. 

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

knmath01_0-1679349614464.png

And then while viewing the report I refreshed using the highlighted

knmath01_1-1679349682304.png

 

 

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_2-1679349772716.png

 

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.

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

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?



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors