How to use PowerBiDesktopClientFactory class of NBi.Core.Query.Client package

Best NBi code snippet using NBi.Core.Query.Client.PowerBiDesktopClientFactory

ClientProvider.cs

Source:ClientProvider.cs

...15            {16                typeof(AdomdClientFactory),17                typeof(OdbcClientFactory),18                typeof(SqlClientFactory),19                typeof(PowerBiDesktopClientFactory),20                typeof(OleDbClientFactory), //It's important to keep this one as the last one because it will handle all the connectionStrings with a provider21            };22        public ClientProvider()23        {24            RegisterFactories(classics);25        }26        public ClientProvider(IExtensionsConfiguration config)27        {28            var extensions = config?.Extensions?.Where(x => typeof(IClientFactory).IsAssignableFrom(x.Key) && !x.Key.IsAbstract)?.Select(x => x.Key) ?? new Type[0];29            RegisterFactories(classics.Union(extensions).ToArray());30        }31        protected internal void RegisterFactories(Type[] types)32        {33            foreach (var type in types)...

PowerBiDesktopClientFactory.cs

Source:PowerBiDesktopClientFactory.cs

...8using System.Threading.Tasks;9using NBi.Extensibility.Query;10namespace NBi.Core.Query.Client11{12    class PowerBiDesktopClientFactory : IClientFactory13    {14        private readonly PowerBiDesktopConnectionStringBuilder connectionStringBuilder = new PowerBiDesktopConnectionStringBuilder();15        public PowerBiDesktopClientFactory()16        { }17        public PowerBiDesktopClientFactory(PowerBiDesktopConnectionStringBuilder connectionStringBuilder)18        {19            this.connectionStringBuilder = connectionStringBuilder;20        }21        public bool CanHandle(string connectionString)22        {23            return !string.IsNullOrEmpty(ParseConnectionString(connectionString));24        }25        public IClient Instantiate(string connectionString)26        {27            if (!CanHandle(connectionString))28                throw new ArgumentException();29            var csb = new DbConnectionStringBuilder() { ConnectionString = connectionString };30            connectionStringBuilder.Build(csb["pbix"].ToString());31            connectionString = connectionStringBuilder.GetConnectionString();...

PowerBIClientFactoryTest.cs

Source:PowerBIClientFactoryTest.cs

...26        public void Get_PowerBiDesktop_AdommdConnection()27        {28            //Call the method to test29            var connStr = "PBIX=My Power BI Desktop;";30            var factory = new PowerBiDesktopClientFactory(new PowerBiDesktopConnectionStringBuilderFake());31            var actual = factory.Instantiate(connStr);32            Assert.That(actual, Is.InstanceOf<PowerBiDesktopClient>());33            var conn = actual.CreateNew();34            Assert.That(conn, Is.InstanceOf<AdomdConnection>());35            Assert.That((conn as AdomdConnection).ConnectionString, Is.EqualTo(PowerBiDesktopConnectionStringBuilderFake.ConnectionString));36        }37    }38}...

PowerBiDesktopClientFactory

Using AI Code Generation

1using NBi.Core.Query.Client;2using NBi.Core.Query.Client.PowerBiDesktop;3using System;4using System.Collections.Generic;5using System.Data;6using System.Data.Common;7using System.Linq;8using System.Text;9using System.Threading.Tasks;10{11    {12        static void Main(string[] args)13        {14            var connectionString = "Power BI Desktop File Path";15            var factory = new PowerBiDesktopClientFactory();16            DbConnection connection = factory.Instantiate(connectionString);17            connection.Open();18            DbCommand command = connection.CreateCommand();19            command.CommandText = "SELECT * FROM [MyTable]";20            DbDataReader reader = command.ExecuteReader();21            DataTable dt = new DataTable();22            dt.Load(reader);

PowerBiDesktopClientFactory

Using AI Code Generation

1using NBi.Core.Query.Client;2using NBi.Core.Query.Client.PowerBiDesktop;3using NBi.Core.Query.Client;4using NBi.Core.Query.Client.PowerBiDesktop;5using NBi.Core.Query.Client;6using NBi.Core.Query.Client.PowerBiDesktop;7using NBi.Core.Query.Client;8using NBi.Core.Query.Client.PowerBiDesktop;9using NBi.Core.Query.Client;10using NBi.Core.Query.Client.PowerBiDesktop;11using NBi.Core.Query.Client;12using NBi.Core.Query.Client.PowerBiDesktop;13using NBi.Core.Query.Client;14using NBi.Core.Query.Client.PowerBiDesktop;15using NBi.Core.Query.Client;16using NBi.Core.Query.Client.PowerBiDesktop;17using NBi.Core.Query.Client;18using NBi.Core.Query.Client.PowerBiDesktop;19using NBi.Core.Query.Client;20using NBi.Core.Query.Client.PowerBiDesktop;21using NBi.Core.Query.Client;22using NBi.Core.Query.Client.PowerBiDesktop;23using NBi.Core.Query.Client;24using NBi.Core.Query.Client.PowerBiDesktop;25using NBi.Core.Query.Client;26using NBi.Core.Query.Client.PowerBiDesktop;27using NBi.Core.Query.Client;28using NBi.Core.Query.Client.PowerBiDesktop;29using NBi.Core.Query.Client;

PowerBiDesktopClientFactory

Using AI Code Generation

1using NBi.Core.Query.Client;2{3    {4        static void Main(string[] args)5        {6            var factory = new PowerBiDesktopClientFactory();7            var client = factory.Instantiate();8            client.ExecuteQuery("SELECT 1");9        }10    }11}12using NBi.Extensibility.Query;13{14    {15        static void Main(string[] args)16        {17            var factory = new PowerBiDesktopClientFactory();18            var client = factory.Instantiate();19            client.ExecuteQuery("SELECT 1");20        }21    }22}23using NBi.Extensibility.Query;24using System;25{26    {27        static void Main(string[] args)28        {29            var factory = new PowerBiDesktopClientFactory();30            var client = factory.Instantiate();31            client.ExecuteQuery("SELECT 1");32        }33    }34}

PowerBiDesktopClientFactory

Using AI Code Generation

1using NBi.Core.Query.Client;2using NBi.Core.Query.Client.PowerBiDesktop;3using NBi.Core.Query.Client.PowerBiDesktop.Factory;4using NBi.Core.Query.Client.PowerBiDesktop.Factory;5using System;6using System.Collections.Generic;7using System.Data;8using System.IO;9using System.Linq;10using System.Text;11using System.Threading.Tasks;12{13    {14        static void Main(string[] args)15        {16            var factory = new PowerBiDesktopClientFactory();17            var client = factory.Instantiate(18                new PowerBiDesktopClientFactoryArgs(19                    new FileInfo(@"C:\Users\testuser\Documents\PowerBI\Sample.pbix"),20                    new FileInfo(@"C:\Users\testuser\AppData\Local\Temp\NBi\Sample.pbix"),21                    new FileInfo(@"C:\Users\testuser\AppData\Local\Temp\NBi\Sample.m"),22                    new FileInfo(@"C:\Users\testuser\AppData\Local\Temp\NBi\Sample.m"),23                    new FileInfo(@"C:\Users\testuser\AppData\Local\Temp\NBi\Sample.m")));24            var cmd = new QueryCommand("SELECT * FROM [dbo].[Sales]");25            var ds = client.Execute(cmd);26            foreach (DataRow row in ds.Tables[0].Rows)27            {28                Console.WriteLine(row[0]);29            }30        }31    }32}33var columns = ds.Tables[0].Columns;34foreach (DataColumn column in columns)35{36    Console.WriteLine(column.ColumnName);37}38var columns = ds.Tables[0].Columns;39foreach (DataColumn column in columns)40{41    Console.WriteLine(column.ColumnName);42}

PowerBiDesktopClientFactory

Using AI Code Generation

1var factory = new PowerBiDesktopClientFactory();2var client = factory.Instantiate();3var result = client.Execute("SELECT * FROM [MyTable]");4foreach (var row in result)5{6    foreach (var cell in row)7    {8        Console.WriteLine(cell);9    }10}11var factory = new PowerBiDesktopClientFactory();12var client = factory.Instantiate();13var result = client.Execute("SELECT * FROM [MyTable]");14foreach (var row in result)15{16    foreach (var cell in row)17    {18        Console.WriteLine(cell);19    }20}21var factory = new PowerBiDesktopClientFactory();22var client = factory.Instantiate();23var result = client.Execute("SELECT * FROM [MyTable]");24foreach (var row in result)25{26    foreach (var cell in row)27    {28        Console.WriteLine(cell);29    }30}31var factory = new PowerBiDesktopClientFactory();32var client = factory.Instantiate();33var result = client.Execute("SELECT * FROM [MyTable]");34foreach (var row in result)35{36    foreach (var cell in row)37    {38        Console.WriteLine(cell);39    }40}41var factory = new PowerBiDesktopClientFactory();42var client = factory.Instantiate();43var result = client.Execute("SELECT * FROM [MyTable]");44foreach (var row in result)45{46    foreach (var cell in row)47    {48        Console.WriteLine(cell);49    }50}51var factory = new PowerBiDesktopClientFactory();52var client = factory.Instantiate();53var result = client.Execute("SELECT * FROM [MyTable]");54foreach (var row in result)55{56    foreach (var cell in row)57    {58        Console.WriteLine(cell);59    }60}61var factory = new PowerBiDesktopClientFactory();

PowerBiDesktopClientFactory

Using AI Code Generation

1var factory = new PowerBiDesktopClientFactory();2var client = factory.Instantiate();3var command = client.InstantiateCommand("select * from [Sheet1$]");4var result = client.Execute(command);5foreach (var row in result.Rows)6{7    Console.WriteLine(row[0]);8}9var factory = new PowerBiDesktopClientFactory();10var client = factory.Instantiate();11var command = client.InstantiateCommand("select * from [Sheet1$]");12var result = client.Execute(command);13foreach (var row in result.Rows)14{15    Console.WriteLine(row[0]);16}17var factory = new PowerBiDesktopClientFactory();18var client = factory.Instantiate();19var command = client.InstantiateCommand("select * from [Sheet1$]");20var result = client.Execute(command);21foreach (var row in result.Rows)22{23    Console.WriteLine(row[0]);24}25var factory = new PowerBiDesktopClientFactory();26var client = factory.Instantiate();27var command = client.InstantiateCommand("select * from [Sheet1$]");28var result = client.Execute(command);29foreach (var row in result.Rows)30{31    Console.WriteLine(row[0]);32}33var factory = new PowerBiDesktopClientFactory();34var client = factory.Instantiate();35var command = client.InstantiateCommand("select * from [Sheet1$]");36var result = client.Execute(command);37foreach (var row in result.Rows)38{39    Console.WriteLine(row[0]);40}41var factory = new PowerBiDesktopClientFactory();42var client = factory.Instantiate();43var command = client.InstantiateCommand("select * from [Sheet1$]");44var result = client.Execute(command);45foreach (var row in result.Rows)46{47    Console.WriteLine(row[0]);48}

PowerBiDesktopClientFactory

Using AI Code Generation

1var clientFactory = new PowerBiDesktopClientFactory();2var client = clientFactory.Instantiate();3var connection = client.InstantiateConnection("C:\\Users\\MyUser\\Desktop\\MyReport.pbix");4var cmd = client.InstantiateCommand(connection, "select 1");5cmd.Execute();6var reader = cmd.ExecuteReader();7while (reader.Read())8{9    Console.WriteLine(reader[0]);10}11var clientFactory = new PowerBiDesktopClientFactory();12var client = clientFactory.Instantiate();13var connection = client.InstantiateConnection("C:\\Users\\MyUser\\Desktop\\MyReport.pbix");14var cmd = client.InstantiateCommand(connection, "select 1");15cmd.Execute();16var reader = cmd.ExecuteReader();17while (reader.Read())18{19    Console.WriteLine(reader[0]);20}21I’ve tried to use the PowerBiDesktopClientFactory class of NBi.Core.Query.Client package to connect to a Power BI Desktop file (.pbix) and execute a query, but I’m getting the following exception:

PowerBiDesktopClientFactory

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Query.Client;7using NBi.Core.Query.Client.PowerBIDesktopClient;8{9    {10        static void Main(string[] args)11        {12            var factory = new PowerBiDesktopClientFactory();13            var client = factory.Instantiate();14            client.ExecuteQuery("SELECT 1");15        }16    }17}18Error CS0246 The type or namespace name 'PowerBiDesktopClientFactory' could not be found (are you missing a using directive or an assembly reference?)

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.