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
Hi csvj_18
Has anyone encountered a similar issue where data is available locally but not after Service refresh?
Yes. Model works correctly in Power BI Desktop because Desktop uses local credentials while service uses different authentication, gateway, parameter and security settings during refresh.
What are the common root causes for this behavior in Fabric / Power BI Service?
Typical causes include incorrect gateway, privacy level conflicts, Row-Level Security filtering out all rows, parameter values changing after publish, incremental refresh partitions excluding data, unsupported query folding in the service.
Are there recommended diagnostic steps or best practices to identify and fix this issue?
Validate data source credentials and gateway mapping in Power BI Service then compare parameter values between Desktop and Service if you are using it. As a test disable RLS and incremental refresh to isolate issue and check refresh history along with dataset row counts. It also helps to test with a table whether specific transformation or source is causing problem