To improve Bud's service to our reporting users, we have implemented a scale-out solution for the Bud Data Warehouse. This means that behind the scenes, there are now two, fully synchronised servers available and a load-balancer will automatically pick the best one to fulfil your request
How to: Faster Access to the Data Warehouse
To take advantage of these performance improvements, all that’s required is to set one of the options below:
1. In PowerBI Desktop:
This can be enabled by selecting the ‘Enable SQL Server Failover support’ under Transform data > Data source settings.
When you publish the report to the PowerBI service, this will also reduce the refresh times of your PowerBI.com reports.
2. Connecting from a client other than PowerBI:
Inform the load balancer that we’re only reading data by adding the following to the connection string:
- In SSMS this can be added under Additional Connection Properties:
- Please note you must also specify the database name as well:
Azure Data Factory (ADF): Edit the relevant linked service, and add a new additional connection property:
For more information on connection strings click here. We strongly encourage all our PowerBI and ETL users to set this flag to gain optimal Data Warehouse performance.