Forum Discussion
Data source credential keep changing from Database type to Windows Authentication after upload
Hi meghashu It is because Power BI Report Server defaults to Windows Authentication when a report is uploaded. It doesn't preserve database credentials from Power BI Desktop, as it relies on server-side credential management for security reasons. To resolve this, manually update the data source credentials in the Report Server to Basic Authentication and save the database username and password. Unfortunately, this adjustment must be made every time the report is re-uploaded unless the server's configuration policies are modified.
Hey meghashu ,
This issue occurs due to the default behavior of Power BI Report Server (PBIRS) when uploading reports created in Power BI Desktop optimized for Report Server (e.g., Jan 2025 version). When you upload a .pbix report to Power BI Report Server, the credentials stored in the Desktop version are not preserved. Instead, the Report Server resets the data source credentials to its default. Since the credentials default to Windows Authentication, but your report connects to a source like SQL Server Analysis Services (SSAS) or a database that expects SQL Authentication.
Yes, unless you automate it. After each report upload, you need to:
Go to the Power BI Report Server Web Portal.
Open the uploaded report's data source settings.
Change:
Authentication Type: To Basic
Set Username & Password manually
Click Apply.
For Detailed Inforamtion:
Configure data sources in Power BI Report Server
Manage data sources for paginated and Power BI reports
Power BI Report Server REST API
Automate Power BI Report Deployment to Report Server
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam