Forum Discussion
Push Refreshing
Hi everyone,
My company has a local database with some sensitive data, a part of this data are used in a power BI report
We would like to use this data but the IT security do not want to allow a direct access to Microsoft to this DB
I would like to know if there is a way to push the needed data in the cloud, and from there, allow my dashboard to use this information
Thank you for your help
Best regards
2 Replies
Hi Anonymous ,
1.In Power BI, Object-level security (OLS) can be used to secure sensitive tables or columns. Secured tables and columns are obscured in the field list when using reporting tools like Excel or Power BI, and moreover, users without permissions cannot access secured metadata objects via DAX or any other method. From the standpoint of users without proper access permissions, secured tables and columns simply do not exist.
Object-level security, together with row-level security, enables enhanced enterprise grade security on reports and datasets, ensuring that only users with the requisite permissions have access to view and interact with sensitive data.
2. Sensitivity labels from the Microsoft Information Protection solution let you classify and protect your organization's data, while making sure that user productivity and their ability to collaborate isn't hindered.
Refer to:
Power BI security white paper - Power BI | Microsoft Docs
Learn about sensitivity labels - Microsoft 365 Compliance | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.