Forum Discussion
Semantic Model shows data in Desktop but empty after Service refresh
The issue is the enterprise credentials on the semantic model is with a different service account. Make sure the semantic gate way connections are using the same service account
I have seen this exact behavior a few times and it almost always comes down to one of two things.
First, check Row Level Security. If any RLS roles are defined and the viewing account is not mapped to a role that returns rows, visuals will look empty even though the refresh succeeded. In the Service, open the dataset, go to Security, confirm your account is in a role, and use Test as role to verify the role's filter actually returns data.
Second, verify the gateway data source. Open Settings on the dataset, expand Data source credentials and Gateway connection, and confirm the connection is mapped to the same database and server you are pointing to in Desktop. A common pattern is the Service ending up bound to a Dev or empty environment while Desktop still reads from Prod.
If both of those check out, also look at any dynamic M parameters or RangeStart and RangeEnd if you have incremental refresh, since a stale or unset value can produce a successful but empty refresh window.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai Karmani