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
- dan7Advocate IMore details posted over in a Reddit thread. https://www.reddit.com/r/MicrosoftFabric/comments/1qk5gya/shortcuts_using_variable_sets_should_break_if/
- frithjof_vCommunity ChampionI agree. The current variable library shortcut default behavior poses a risk of data pollution across environments.
- dan7Advocate I"data pollution" I like that description. So on target.
Recent ideas
Improve support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya3 hours agoNew MemberNew8Views0likes0CommentsAllow Bottom-Up Hierarchy Expansion in Power BI Matrix for Financial Statements
Allow Bottom-Up Hierarchy Expansion in Power BI Matrix for Financial Statements Hi, I would like to request an enhancement to the Power BI Matrix visual that allows hierarchies to be expanded from t...Barbarini6 hours agoRegular VisitorNew8Views0likes0CommentsAllow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types
Fabric External Data Sharing provides an excellent zero-copy mechanism for sharing OneLake data across tenants. However, the receiving tenant currently has to accept the share into a Lakehouse. I w...Mourak2 days agoNew MemberNew9Views0likes0CommentsAllow OneLake Shortcut Authentication Mode to Be Changed In Place
OneLake shortcuts support passthrough and delegated authentication, but changing the authentication model currently requires deleting and recreating the shortcut. I would like shortcut authenticatio...Mourak2 days agoNew MemberNew9Views0likes0Comments