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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
UncleLewis
Helper V
Helper V

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
Memorable Member
Memorable Member

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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