In ODBC connection, is it possible that when user open report DSN name gets changed automatically

[sonu123456]

I have created ODBC connection in Power BI report. It has 15+ DSN names If I shared the report to users then users can view the report as per user DSN without changing the DSN name, is it possible that DSN name will change automatically when user opens the report? #powerbi #Powerbiservice, #powerquery

[v-jialongy-msft · Accepted solution]

Hi @sonu123456 

In Power BI, DSN names for ODBC connections are typically static in the report configuration and do not automatically change based on the user viewing the report. The DSN name is part of the connection information that Power BI uses to access the data source during report refreshes or when the report is accessed by users.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.