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