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.
I have a database which is in my local system. Trying to connect the same with Power BI desktop using SQL Server Databse and for connection given the server name as my system's name. When trying to get connected it is showing an error.
Can anyone let me know the steps to connect to the databse??
I used:
(localdb)\MSSQLLocalDB
as the servername and that worked for me.
Hi @sujaysbhat,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi @sujaysbhat,
Is your database SQL Server 2000? If so, I'm afraid it isn't supported by Power BI Desktop. The minimum supported version of SQL Server is SQL Server 2005. Please refer to: powerbi-desktop-data-source-prerequisites.
Best Regards!
Dale
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |