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.
Can I connect to MS SQL2000 using a native client? There seems to be a problem in the latest version of Power BI Desktop in April.
Solved! Go to Solution.
Hi @zoltym ,
You may refer to following offical blog about Power BI data source prerequisites.
Power BI currently support the Minimum data source version of SQL Server is SQL Server 2005+. So Power BI Desktop doesn't support SQL 2000.
If you want to use SQL Server connecter in Power BI, please upgrade your SQL Server version to the latest version and try again.
For reference: Refresh data from an on-premises SQL Server database
Or you can try ODBC connecter.
Here is a post with a similar problem like yours, I hope it could help you.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @zoltym ,
You may refer to following offical blog about Power BI data source prerequisites.
Power BI currently support the Minimum data source version of SQL Server is SQL Server 2005+. So Power BI Desktop doesn't support SQL 2000.
If you want to use SQL Server connecter in Power BI, please upgrade your SQL Server version to the latest version and try again.
For reference: Refresh data from an on-premises SQL Server database
Or you can try ODBC connecter.
Here is a post with a similar problem like yours, I hope it could help you.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The error with connecting to MS SQL2000 does not appear until the April 2022 version. I know I can replace it with ODBC.
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |