Power BI for external customers their own data

[mmossel]

Hi, imagine software company ABC that designs and delivers enterprise software and related professional services.

ABC wants to create reports to publish to their own customers (enterprises) on the use of these customers' own data. The data is collected in the ABC's own environment from the cloud instances they have. ABC manages their customers' cloud apps, collects data about what they use from their own databases, and wants to build a report on it and publish it in a community view.

That would mean that there should be one dashboard and that different data is displayed for each customer that logs in.

What would be the best practice for this, thinking of the security model too?

[V-lianl-msft · Accepted solution]

Hi @mmossel ,

Please refer to these blogs:

1.

RLS

https://superfarb.com/power-bi-row-level-security-while-sharing-with-external-users/ 

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple 

2.

Data masking

https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking 

https://radacad.com/secure-the-sensitive-data-in-power-bi-data-masking-better-with-row-level-securit... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.