Forum Discussion
Specific Columns turn empty after refreshing Semantic model in Powerbi Service
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???
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!
15 Replies
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.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.
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!
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
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)
- 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.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.
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.
