Are only SQL Server Analysis Service databases possible when adding a data source?

Tored — Thu, 09 Mar 2023 07:13:55 GMT

When I connect my database (SQL Server) as a data source, Power BI tells me that it is a SQL Server Analysis Service database, even though I don't want to connect an Analysis database at all, but just a normal SQL Server database.

My Code:

string dataSource = "LocalSQLServer"; dbWithDataSource.Model.DataSources.Add(new ProviderDataSource() { Name = dataSource, Description = "A data source definition that uses explicit Windows credentials for authentication against SQL Server.", ConnectionString = "Provider=SQLNCLI11;Data Source=MyDatabaseServer;Initial Catalog=MyDatabase;Integrated Security=SSPI;Persist Security Info=false;", ImpersonationMode = Microsoft.AnalysisServices.Tabular.ImpersonationMode.ImpersonateAccount, Account = @"AccountName", Password = "password", }

Re: Are only SQL Server Analysis Service databases possible when adding a data source?

luisrh — Thu, 09 Mar 2023 00:25:00 GMT

TOM is for Tabular Object Models, not sql server.

Re: Are only SQL Server Analysis Service databases possible when adding a data source?

Tored — Thu, 09 Mar 2023 07:14:15 GMT

You're right. I have adjusted the initial post.

topic Are only SQL Server Analysis Service databases possible when adding a data source? in Developer

Are only SQL Server Analysis Service databases possible when adding a data source?

Re: Are only SQL Server Analysis Service databases possible when adding a data source?

Re: Are only SQL Server Analysis Service databases possible when adding a data source?