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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kyleb350
Helper I
Helper I

ODBC Connection String Properties Static Between Reports?

I have two reports, one of which is a variant that is to access a different database (a different company code specifically). The two reports are identical otherwise.

 

I've successfully constructed the second report, entering the credential connection string properties Company=XXX, and it works, but suprisingly, that string sticks to every single report that I've built using that data source in Power BI! So, when I switch it back on the other reports, it reverts my variant report to the company code I did not intend for it to use.

Screenshot 2021-05-24 164958.jpg

Can I get this string only to be attached to this particular report, or do I need to construct a whole new ODBC datasource with this new connection string?

1 ACCEPTED SOLUTION
kyleb350
Helper I
Helper I

I've solved this by instead adding the connecton string property at the query level in the Power Query editor.

 

The second step is to make sure to add this as a new data source in the data gateway (if you wish to auto refresh).

 

Thanks @Greg_Deckler for the response as I started some research on using parameters too. A whole new area for me to learn!

View solution in original post

2 REPLIES 2
kyleb350
Helper I
Helper I

I've solved this by instead adding the connecton string property at the query level in the Power Query editor.

 

The second step is to make sure to add this as a new data source in the data gateway (if you wish to auto refresh).

 

Thanks @Greg_Deckler for the response as I started some research on using parameters too. A whole new area for me to learn!

Greg_Deckler
Super User
Super User

@kyleb350 I would construct your connection string using a query parameter for the unique portion of the connection string.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.