Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Yes this looks correct
eg Data Source=ABCD;Initial Catalog=contoso
you may use build connection and Test Connection to check :
I think, it is correct. With SQL datasource you can also use:
ServerName;my_db
If still cannot connect, which error mesage is raised?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |