Add support for Azure SQL Database read-only replica for gen2 dataflows
Allow gen 2 dataflows to refresh data from a Azure SQL Database read-only replica (using [MultiSubnetFailover=True]).
Steps to reproduce:
- Create an Azure SQL Database on the Business Critical tier
- Create a dataflow with the M query code as below, replacing [DatabaseServer] and [DatabaseName] with the details of your Business Critical Azure SQL database.
let
Source = Sql.Database("[DatabaseServer]", "[DatabaseName]", [CommandTimeout = #duration(0, 2, 0, 0), Query = "SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability') AS Updateability", MultiSubnetFailover = true]),
#"Transform columns" = Table.TransformColumnTypes(Source, {{"Updateability", type text}}),
#"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"Updateability", null}})
in
#"Replace errors"
- Note that the query returns “READ_ONLY” in the PowerQuery preview
- Save and refresh the dataflow
- Connect to the dataflow in PBI Desktop. Note that the dataflow now returns “READ_WRITE”, indicating that it has refreshed using the primary instance and not the read only replica as would be expected.
The above behaviour occurs whether an on-premises data gateway is used or not.
Please add support for gen2 dataflows using a read-only replica irrespective of whether the gateway is used or not.
Recent ideas
Support Native SQL LIKE / NOT LIKE Wildcard Filtering Across Power BI Reports
Description Currently, Power BI does not provide a native way for report consumers to perform dynamic SQL-style wildcard filtering using patterns such as LIKE '____' - Above return all values wit...Seeralan30 minutes agoNew MemberNew3Views0likes0CommentsRetain Matrix/Table Scroll Position When Returning from Drillthrough
Description: Currently, when users drill through from a Matrix or Table visual to a detailed page and then use the Back button to return, the report navigates back to the source page but resets the ...Pruthviraj151 hour agoNew MemberNew8Views0likes0Comments