Forum Discussion
Data loading resets columns definitions
Hi,
We have a PBIX that loads data from Azure SQL views. We've added a few columns to a view, but each time we refresh the data in Power BI Desktop, among other issues, all columns in all tables that are marked "hide in report view" are reset and become visible in the model. Annoying to put it mildly. Our Model is large and re-aplying these settings over and over is a drag.
Anyone else expierencing this? Workarounds? Fixes?
Found the answer in another thread: https://community.powerbi.com/t5/Issues/Hide-columns-reset-to-unhidden-when-refreshing/idc-p/1719363/highlight/true#M65061
Still, it's funny that you need to enable a preview feature to stop BPI Desktop from overwriting your work..
3 Replies
sjoerdvn , There some old explanation, see if this can help
Nope, was already refreshing from Data view.
Found the answer in another thread: https://community.powerbi.com/t5/Issues/Hide-columns-reset-to-unhidden-when-refreshing/idc-p/1719363/highlight/true#M65061
Still, it's funny that you need to enable a preview feature to stop BPI Desktop from overwriting your work..
