Forum Discussion
Restricting access to Datamart connection string
Hi, I am trying to allow an external customer to mix their data with my organizations and build their own reports, but we want to restrict them from extracting all of our data in bulk. I am t...
It's not possible to prevent external customers from connecting to the Power BI datamart via the connection string. However, you can secure the connection string by making sure it is encrypted and stored securely. Additionally, you can restrict access to the datamart by implementing role-based access control, so that only authorized users have access to it. Another option is to use DirectQuery or Live Connection instead of Import mode, which allows you to connect directly to the source data and eliminates the need to download a copy of the data. This way, customers will only have access to the data they need, and the connection string will be hidden.