Integration website and Power BI

[kbmbarreto]

Good afternoon people.

I wonder if the following is possible:

Suppose I have a web site with a user restricted access area and password, where my clients can view information for themselves through a Power BI report that I have on my site.

Can I limit access to this report information, based on the password of the user who logged in to my site?

Thanks. 

[v-qiuyu-msft]

Hi @kbmbarreto,

After publish to the Power BI service, we need to specify the credential for the dataset, assume you specify the accountA to access the website data source, everyone view the report will use this accountA to access the website data source. So based on the password doesn't make sense. 

For your requirement, you can use Row-level security (RLS) with Power BI. 

Best Regards,
Qiuyun Yu 

[kbmbarreto]

Good afternoon,

In fact, I thought of something as a federation.

So when the customer logs into the site, he would already have access to the views of his company.

Sincerely, Kleber Barreto.

[v-qiuyu-msft]

Hi @kbmbarreto,

Power BI service uses dataset credential to access the web site, as the dataset credential is "fixed", to limit user access different data, we need to set RLS on Power BI side as suggested before. 

Best Regards,
Qiuyun Yu