Push Refreshing

[Anonymous]

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

[v-eqin-msft]

Hi @Anonymous ,

Could you tell me if my post helps you? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌😀

Best Regards,
Eyelyn Qin

[v-eqin-msft]

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 Whitepapers

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.