cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
soldous Frequent Visitor
Frequent Visitor

Connection information in downloaded pbix

Hello everyone,

 

when I create a connection to a data source in Power BI Desktop the connection is saved in the data source settings right? And what if I published the report with that data source into Power BI Service and another user will download the pbix? The connection is still saved? 

So theoretically the other user can then access into the data source under the identity I created? This could be a serious security issue in some cases if I understand it right.

 

Thanks for the explanation.

3 REPLIES 3
Super User
Super User

Re: Connection information in downloaded pbix

Hi there

Depending on the data source that you are connecting to will mean how the user gets authenticated.

For example if you have a SQL Server data source, which YOU have permissions to.

Another user downloads the PBIX which will have the connection details to the SQL Server, but if the connection properties are set to use "Current User Name and Password" it will then require the other users details to authenticate against the SQL Server. If this user does not have the access they will not be able to access the data.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Highlighted
soldous Frequent Visitor
Frequent Visitor

Re: Connection information in downloaded pbix

@GilbertQ Thank you for your answer.

You are right when we're talking about Windows kind of login but what about a database user name and password? When I use database user name and password and it represents my identity in the data source system will the other user use that my identity after he downloaded the pbix from PBI Service?

Super User
Super User

Re: Connection information in downloaded pbix

I think it should prompt for the details

 

I would suggest completing a small test, download the file and see if you get prompted?


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)