Prompt User Credentials for Web Data Source

[aaron797]

Hi,

I have a "web" data source for a report that i have created,

When i publish this report to Power Bi for other users to view, they are able to see all of the data that i have access to, it appears to store my credentials to the data source within the report.

Is it possible to prompt users of this report accessing through https://app.powerbi.com/ for their own credentials to the web data source, to return the records only they should have access to?

Thank you.

[Anonymous]

Hi @aaron797 ,

In my opinion, this is not possible. When you load data form data source with your credential, the dataset you created only contains parts of data.

Let's say there're 10 rows in data source, you load 7 rows with your credential and share the report to other users, the dataset and report only contains 7 rows and no matter what credential the other users use, they can only see at most 7 rows.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

Should be possible with power bi pro and premium

https://docs.microsoft.com/en-us/power-bi/service-admin-licensing-organization

https://docs.microsoft.com/en-us/power-bi/service-admin-purchasing-power-bi-pro

[aaron797]

Thanks @amitchandak,

Our users are all on Power Bi Pro, the credential prompt im looking for is for the Web datasource itself (Third party website) not a microsoft account.