Forum Discussion
PowerBI report server publishing
Hi, What is the guidence for using expressions/variables for the connection strings to data sources. We have two challenges to overvcome to make sure the publishing of models works. 1) Data s...
The way to do this is to ensure your datasources are embedded data sources - after that you can create your connectionstring thru an expression. One common way is to pass info necessary for it thru hidden parameters -
From a security standpoint I would ensure those params are hashed and your functions in the SSRS side manage unmangling the passed parameters used for connectionstring building.