Forum Discussion

meghashu's avatar
meghashu
Regular Visitor
1 year ago
Solved

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 Po...
Data source credential lost after upload
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi meghashu ,

Thank you for reaching out to the Microsoft Fabric Community. Also thank you Akash_Varuna  and Nasif_Azam for your insights.


I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.