Forum Discussion
SQL Authentication username/password security in Power BI Desktop
Hi, If I use a SQL username/password in Power BI Desktop to connect to SQL Server (either DirectQuery or Import), is there a possiblity that the SQL username/password can be extracted from the /p...
Anonymous, If you rename the .pbix file to.zip, you have access to the underlying data files. You will find the DataMashup file and DataModel file. The DataMashup file contains the SQL Server name, domain, database, schema and table details. And the DataModel file contains the user profile name. Anyone who opens the .pbix file can get the server name, database name and even credential name related information.
Even though SQL authentication appears to be encrypted in the file and not visible by other users. However, I still don't think it is a good idea to share a .pbix file with anyone don't trust or post it publicly.