Variable Library: Shortcuts with variable value that doesn't resolve a path should error out.
When using a variable library to actively set shortcut path information (workspace, item, path) if a selected variable value(s) result in a non-existent location, the intentional assignment of the variable value should be forced into the shortcut, which shall cause a shortcut error that would be visible in the left hand lakehouse explorer/navigation (red X or similar error symbol).
The current default keeps the old or default value, which could erroneously have some shortcuts pointing to the new value while others in the same lakehouse point to an old value. For example, this could expose DEV tables in a TEST lakehouse when the intended selection of the TEST variable value set is to only show valid shortcuts to underlying TEST location. Other than the error at the time of updating variables on the lakehouse, there is no perminent indication for users in the future that some of the shortcuts are not pointing at the desired location.
Similar to frithjof_v idea disabling the default value when a variable library is deployed across workspaces and a selection is not made, but differs by forcing an error when a selection is actively made that doesn't resolve to a valid path. The other speaks to avoiding the default if no selection is made.
3 Comments
- dan7
Advocate I
More details posted over in a Reddit thread. https://www.reddit.com/r/MicrosoftFabric/comments/1qk5gya/shortcuts_using_variable_sets_should_break_if/ - frithjof_v
Community Champion
I agree. The current variable library shortcut default behavior poses a risk of data pollution across environments. - dan7
Advocate I
"data pollution" I like that description. So on target.
Recent ideas
Enable sorting of diagram pages in Power BI Desktop
I, as a developper, rely a lot on model view and diagrams... It's annoying to not be able to sort the diagram pages in this view, since I tend to try to organize these by subject and it becomes a...Daproulx5 minutes agoFrequent VisitorNew2Views0likes0CommentsImproving complexity of Page Navigator in PowerBI
The page navigator could be improved in multiple ways to help reports that have many pages: Allow scroll in vertical view Allow pages within the navigator (EX: using a right and left carrot to sho...kreid5 hours agoNew MemberNew77Views2likes2Comments