cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UncleLewis
Super User
Super User

Data Source Connection String

Hi all,

 

Using Power BI Report Server

Trying to create a new data source to SQL Server

 

I used connection string like this

Data Source = ServerName;Initial Catalog = my_db

I'm using my Windows credentials

 

But I still cannot connect

Is my connection string correct

The server name and Catalog(db) are stright from SSMS.

 

Thanks,

-w

2 REPLIES 2
AbhiSSRS
Solution Sage
Solution Sage

Yes this looks correct 

eg Data Source=ABCD;Initial Catalog=contoso

 

you may use build connection and Test Connection to check :

AbhiSSRS_0-1635449025750.png

 

josef78
Super User
Super User

I think, it is correct. With SQL datasource you can also use:

ServerName;my_db

If still cannot connect, which error mesage is raised?

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Kudoed Authors