Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
6 | |
5 | |
5 | |
3 | |
2 |