Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Tored
Frequent Visitor

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

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", 
}

 

 

image.png

2 REPLIES 2
luisrh
Responsive Resident
Responsive Resident

TOM is for Tabular Object Models,  not sql server.   

Tored
Frequent Visitor

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.