Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sonu123456
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
v-jialongy-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.