Most fields are already filled in. Otherwise, you might encounter an error that says that "The OAuth authentication method is not supported in this data source". This new option can be found under the "Advanced Options" section in the SQL Server connector dialog. That idea you refered to might possible solve this, but it's actually not the same thing. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Select OK to connect to the database by using an unencrypted connection, or follow these instructions to setup encrypted connections to SQL Server. After selecting this transformation, you will get prompted to provide a delimiter to use in the new column. Make sure you point to the AdventureWorksProducts dataset, not the report with the same name, which doesn't have a Schedule refresh option. If checked, the Navigator displays the complete hierarchy of tables in the database you're connecting to. This option is only available in Power Query Desktop. Find out more about the April 2023 update. The connected workspace approach follows a similar approach to the "Native" workspace approach. However, it requires customization and a clearly documented process to redirect applications to the new gateway. You can pick between As zero, Dont format, and Specific color. Taking over the existing gateway should be simpler, because all the data sources associated with the old gateway are carried over to the new one. Optimize Power Query when expanding table columns, More info about Internet Explorer and Microsoft Edge, Import data from a database using native database query. When "Enable SQL Server Failover support" is checked, it adds "MultiSubnetFailoverSupport = True; ApplicationIntent = ReadOnly" to the connection string. User-defined restore points - Azure Synapse Analytics, Create DNS alias for dedicated SQL pool in Synapse workspace for disaster recovery. Read operations, such as displaying dashboards and displaying reports (that aren't based on DirectQuery or Live Connect to on-premises data sources) continue to function normally. In order to achieve a connection to the Read Only Replica of a SQL DB from Power BI, I've noticed this more or less official practice of using this advanced option based on the assumption that once choosing the option: Enable SQL Server Failover support, simultaneously and "under the hood" the parameter ApplicationIntent is set to ReadOnly. The aim is to help you create a plan . With these factors in mind, we can start to draft our custom plan. If this is denpending an the GW configuration, or if this is an comming feature, I don't know. If you don't see a gateway, make sure you followed the instructions to install an on-premises data gateway. The SQL Server connector has been improved in this release, adding a new option to enable SQL Server Failover support. I understod your answer as: failover support is currently not supported in Power BI GateWay.
Why Does Yogurt Upset My Stomach But Not Milk, Bald Cypress Leaf Margin, Articles P