Forum Discussion

eaglesilo's avatar
eaglesilo
Frequent Visitor
2 years ago

PowerBI workspace against Read-Only Scaleout settings?

Greetings.


tl;dr:  How can I audit the connection parameters for each table connection across the entier organziation, or is it possible to Manage Connections in PBI to force against the ReadOnly Scaleout?

My organization is an Azure shop on the Premium P2 tier with ReadOnly Scaleout enabled. (Simply what this means is that we have a real time readonly instance of our database that we can run reporting against.)

 

Over the past years I've published dozens of PBI reports across multiple workspaces, each containing multiple dozens of tables connected to the server. When pulling data from the server, we make sure that the Source Connection contains the MultiSubnetFailover=true parameter (example below), but it appears I've missed a few tables somewhere, as when running sp_whoisactive in the database turns up queries triggered from PBI.

Let Source = Sql.Database(Server, Database, [Query= "query", MultiSubnetFailover=true])
in Source

 

Besides opening each and every PBI report and every table in each report, is there any way to determine which Report or which table in which report may possibly not have MultiSubnetFailover=true enabled in the source definition?

 

Or, is there an option from within a Workspace, one can Manage all the Connections and Gateways that exist for that workgroup. Is it possible to update the Connection parameter to only run against a Read Only Scaleout of the database connection?

 

 

 

 

 

 

2 Replies