Specific Columns turn empty after refreshing Semantic model in Powerbi Service

[KiaZ]

Refresh Problems PowerBI Service

Hi Everyone,

I have some problems when refreshing my dashboard in PowerBI Service. Whenever i publish my dashboard to the Service platform, its working correctly but then, when i refresh the model in Service for some reason 3 specific columns in table visual in my dashboard just turn empty. Like they dont show data, while in the Desktop mode it works perfectly fine. Now I have tried lots of things, for example:
1. Changing my data types
2. Dax Formatting (these 3 columns dont even use a measure)

3. Filtering

4. Checking the Onpremise Datagateway, and relationships

Now i dont know what to do to fix it, just because its specific 3 columns. And not like the complete dashboard. Does somebody know what i can do to fix this???

[Anonymous]

Hi @KiaZ,

Thanks for reaching out to the Microsoft fabric community forum. When a visual works right after publish but specific columns go blank only after a Service refresh, it’s usually because the refreshed data in the Service isn’t matching/joining the same way it does in Desktop. The most common reason is a Power Query merge/expand across multiple sources where Privacy Levels are different in the Service, so the merge returns nulls on refresh. Another frequent cause is key/value mismatches after refresh (whitespace, casing, type/culture) that break the relationship only for those fields. As @Shahid12523 gave some trouble shooting steps kindly go through them and check if your issue can be resolves and also if non of the steps help then as @FBergamaschi suggested kindlky raise a support ticket with the Microsoft Support Team.

I would also take a moment to thank @FBergamaschi, @MasonMA and @Shahid12523, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

[KiaZ · Accepted solution]

Hi There,

After trying a lot of things, i decided to just reload my table from my datawarehouse. Because i had many filters/adjustments over my columns. When i loaded my table fresh into my dashboard and minimized filtering etc. it worked!

Thankyou all for the support!

[Anonymous]

Hi @KiaZ,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround so that other users can benefit as well.  And if you're still looking for guidance, feel free to give us an update, we’re here for you.

Best Regards,

Hammad.

[MasonMA]

@KiaZ 

Similar issue happened to me once and it could be one of the possible causes. 

The model is Import and Desktop has a local cache of data (the last refreshed on machine). When i publish, that cached data is packaged inside the PBIX and uploaded. It “looks fine” immediately after publishing because Service is still showing your cached copy. But after Service refreshes, it pulls fresh data from the source, and if there’s any mismatch (missing columns, gateway differences, schema drift), those specific columns can suddenly go blank.

[KiaZ]

@MasonMA 

Yes indeed, my data is in import mode and not direct query. But How did u fixed it? And how can i make sure it works just like the rest of the data? Its all from one Import Data source.

[MasonMA]

Well, i can only advise based on my past experiences. Since you mentioned in one of the messages that the data in these columns refreshes all right when you refresh the desktop file, which rules out the old 'Cached' data in Import. 

[KiaZ]

@MasonMA 

I just cleared the cache, stil happening...

[Shahid12523]

- Time Zone mismatch: Service uses UTC, so TODAY() or NOW() might behave differently. Adjust for offset.
- Query folding broken: Complex Power Query steps may prevent proper refresh. Simplify transformations.
- Gateway issues: Schema or credentials may not sync correctly. Recheck mappings and refresh Desktop before republishing.
- RLS or permissions: Columns may be hidden due to row-level security. Test with “View As” roles.
- Metadata ghosting: Columns may be stale in the semantic model. Rebuild them or refresh via XMLA/Tabular Editor.

[FBergamaschi]

Can you show some images of the issue?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[KiaZ]

Yes Ofcourse,

In the following picture (1st picture) u see 3 columns in my table visual from my dashboard in the desktop mode, when i publish it to the service platform it works as it should. But then when i refresh it in the Service platform they turn empty showing no data in return (2th picture)

[KiaZ]

@FBergamaschi 

[FBergamaschi]

OK thanks so in the Service, it gets empty after refresh

When you refresh in Desktop, does the column gets empty too?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[KiaZ]

Nope, if i refresh it in desktop mode. It gives me new fresh data. And when i publish it to the service platform it works as it supposed to be. But when i refresh it in Service, the columns get empty.

[KiaZ]

@FBergamaschi 

[FBergamaschi]

My suggestion then is to open a support ticket to Microsoft

This is to be done via 

https://admin.powerplatform.microsoft.com/

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI