data source credential lost after upload
1 Topic
Data source credential keep changing from Database type to Windows Authentication after upload
In my PowerBI report at PowerBI Desktop (Jan 2025), datasource is configured with Credentials of type Database and has Database user name and Password saved. But when upload this report to on-prem PowerBI report server (Jan 2025), Credentials of the report automatically change to Windows Authentication and 'As the user viewing the report'. Why this change is happening? Due to this, when trying to run the report, we get the following error: "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly." Do we have to manually modify Credentials to Basic Authentication, alongwith User name and Password, every time the report is uploaded from Desktop to Report server?Solved2.2KViews0likes4Comments