Forum Discussion
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
- GilbertQ
Super User
Hi eaglesilo
There is good news in that if you use the Scanner API data you can then view the data source queries for each of your semantic models where you can then search for the issue you are having.
Here is the link to enable the scanner API https://powerbi.tips/2021/10/using-the-power-bi-scanner-api-to-manage-tenants-entire-metadata/
- AnonymousNot applicable
Hi eaglesilo ,
May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.