User Profile
chris_Stei
New Member
Joined 2 years ago
User Widgets
Contributions
Re: Setting Privacy Settings in a Shared Excel File with Database Connection
Hi rubayatyasmin, thank you for your suggestion. They might work in different scenarios, but unfortunately not in our case. We set the data protection setting in the centralized excel file. But every user has to set it again, until he saved the file afterwards, which is not our mandatory intention. The PowerBI centralized data model would require, that all users (>400) have to have a user based licence. This effort is not covered by the business case in the next 5 years. A SSRS centralized data model doesn't cover our requirements of passing parameters from excel to the data source. Best regards Chris1.1KViews0likes0CommentsSetting Privacy Settings in a Shared Excel File with Database Connection
Hello Community, I'm facing a challenge while using Power Query in conjunction with a shared Excel file. This file contains a database connection, and I'm trying to standardize privacy settings for all users. The current situation is as follows: Privacy settings for the database connection are set to "Private." The Excel file is centrally provided for multiple users with read-only access. When opening and updating data via the connection, users are prompted for privacy settings. Since users only have read-only access to the file, they can't save the settings, potentially leading to different settings being used. we are using Excel as part of Microsoft 365 Apps for Enterprise the database is on a onPrem server instance the web application is hosted in the IIS on this database server My question is: How can I set privacy settings for this Excel file so that they are uniform for all users and cannot be individually changed? I would greatly appreciate any assistance or guidance you can provide on this matter. Best regards, Chris1.2KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.