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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Different users seeing different numbers *not security*

Hello, I have users who are inexplicably getting different results from the same report.

I built this report several months ago, but have since switched departments. The current curator of the report came to me saying that data isn't populating for herself and the vast majority of users.

 

So we did some investigating:

- I can still see all of the data, but she and the users can't, neither she on her desktop copy, nor her nor them on the Server version.

- Data refreshes have been working fine.

- Security code has remained the same, and none of the tables related to the security fields have changed. Security is properly applying to users, the data simply isn't there for them.

- In fact, nothing about any of the tables has changed.

- User access has remained the same.

- She and I are the two primary admins, and we have the same permissions and same version of PBI. We publish to a premo workspace.

 

- Now this is extra strange; we swapped local copies and with her copy I got the same results that my local copy produced, and the copy I sent her produced for her the same results as what her copy produced for her.

- Our local copies use our DB creds, but the copy in Server refreshes using a PID via a gateway. Data sources are both Dynamics and an IBM DB2 DB.

- Incrimental refresh is not used. Even if it was, we would have seen it when we swapped copies.

 

All of this seems to point to some sort of security issue, but I haven't the slightest idea why it is occuring. Everything that I can think of is exactly the same between us.

This came to our attention about three weeks ago (so, late September). I was only contacted abot it last week.

What is going on?

 

Below you can see the two variants of data that people are seeing. Note the massive differences. The first one is correct, the second is utterly wrong. Yes, for privacy I redact my screenshots. There's nothing there you need to see.

MyversionRedacted.pngHerversionRedacted.png

I created a forum threat on this in case it isn't Issue-worthy: https://community.powerbi.com/t5/Service/Different-users-seeing-different-numbers-not-security/m-p/5...

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @jengwt,

 

Please create a support ticket to let engineers look into the report on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Delivered