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.
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.