Forum Discussion
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 constructe...
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!
Anonymous I would construct your connection string using a query parameter for the unique portion of the connection string.