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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors