Forum Discussion
Setting Privacy Settings in a Shared Excel File with Database Connection
Hi, chris_Stei
Suggest your users to select "Ignore Privacy Level Checks for this file" when the window pops up.
Also, check the article
Set privacy levels (Power Query) - Microsoft Support
Also, a few suggestion
1. You can leverage the Group Policy to standardize user settings.
2. How about a centralized data model? This can be done using Power BI or a similar tool where the data is imported and transformed centrally. Then the Excel file connects to this centralized model rather than directly to the database. This approach minimizes the need for users to have their privacy settings configured.
3. For On-prep use need to use a data gateway. This way, all users can connect through a unified gateway which has its privacy level settings controlled centrally.
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
Chris
