Restricting access to Datamart connection string

[kpia]

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 testing using Power BI Datamarts as it will allow my customers to add their own data sources, create realtions, measure and reports all in the browser. 

I know I can restrict them from downloading the underlying dataset but is it possible to prevent them from connecting to the Datamart via the connection string?

I looked in the Mircosoft documentation but can find it anywhere. 

[kpia]

There is no current solution that I know of that will allow an External User to build reports without the ability to export all data. 

I submited an Power BI idea for this. Please upvote if this is a feature you are interested in.

https://ideas.powerbi.com/ideas/idea/?ideaid=9f0fbdfc-c6a8-ed11-9ac5-281878e6855d

[kpia]

@jaweher899 Thanks for the response....Your suggestion with the direct query will work but I was trying to avoid this option because the customer can still connect to the model with DAX Studios and extract all data.

There doesn't seem to be a way in Power BI to allow users to add/model data without opening up the vulnerability of them extracting all the data.

[jaweher899]

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.