Create DirectQuery Datasest with XMLA Endpoint doesn't automatically select gateway

Clampazzo — Fri, 22 Sep 2023 12:26:39 GMT

I am currently building a directquery dataset via code and xmla endpoint. I have been able to create the dataset in my workspace however when I navigate to the online dataset it doesn't have the gateway connections automatically set. I have to then takeover the dataset, navigate to gateways and then it will auto fill out the correct gateway.

Is there a way I can do this in code? Below is what I'm seeing and then the code I am using.

When first created there are no tables:

Then after I navigate to settings, click on take over settings, and open gateway and cloud connections it automatically finds the correct connection and loads it.

I navigate back and the tables are already filled in. The only thing I did was takeover and navigate to the connection.

Is there a way I can do this via code so that this is automatically done?

public static void CreateWingtipSalesModel(Database database) { Model model = database.Model; Table tableCustomers = CreateCustomersTable(); model.Tables.Add(tableCustomers); model.SaveChanges(); model.RequestRefresh(RefreshType.Full); model.SaveChanges(); } private static Table CreateCustomersTable() { Table customersTable = new Table() { Name = "Case", Description = "Case table", Partitions = { new Partition() { Name = "All Cases", Mode = ModeType.DirectQuery, Source = new MPartitionSource() { Expression = Properties.Resources.CustomersQuery_m } } }, Columns = { new DataColumn() { Name = "Case_ID", DataType = DataType.Int64, SourceColumn = "Case_ID", IsHidden=false }, new DataColumn() { Name = "Category", DataType = DataType.String, SourceColumn = "Category" } } }; return customersTable; }

The Customers Query M code is below:

let Source = Sql.Database("CONNECTION", "DATABASE", [MultiSubnetFailover=true]), FieldProc_vwCase = Source{[Schema="dbo",Item="table"]}[Data] in dbo_table

Re: Create DirectQuery Datasest with XMLA Endpoint doesn't automatically select gateway

lbendlin — Sat, 23 Sep 2023 20:37:03 GMT

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Also this: Datasets - Take Over In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

topic Re: Create DirectQuery Datasest with XMLA Endpoint doesn't automatically select gateway in Developer

Create DirectQuery Datasest with XMLA Endpoint doesn't automatically select gateway

Re: Create DirectQuery Datasest with XMLA Endpoint doesn't automatically select gateway