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
Deployment Pipelines - Remember selected stage
Every time we go into a deployment pipeline, it defaults to selecting the Development stage. I believe that it would be very rare to have a user select the Development stage. It would be helpful if d...PeterDaniels6 hours agoAdvocate IINew1View0likes0CommentsDisable auto-restore previous session's tabs in new Fabric sessions
Description: Since a recent update, starting a new Fabric session — for example by opening Fabric in a new browser tab — automatically reopens all the item tabs that were left open from a previous s...MathieuVr13 hours agoFrequent VisitorNew56Views5likes1CommentExported PDF from PowerBI to not have any indents/borders
Currently, using the "Export to PDF" option in PowerBI results in two consistently buggy results: A white border/indent is generated, increasing the size of the page from 8.5x11 to 9x11.5 Sometime...EliShalev16 hours agoNew MemberNew13Views0likes0CommentsAdding a Container for Logical Grouping of Activities in Data Pipelines
Dear Team, I would like to propose a feature enhancement for Data Pipelines in Microsoft Fabric that allows the logical grouping of activities into a container. This container would serve to: Im...lukas_karlovsky17 hours agoNew MemberPlanned877Views15likes5Comments