Share via

Compatibility Issues Power BI / SQL (version mismatch?)

Anonymous
2025-02-25T18:14:12+00:00

Hello,

I am working on building a set of SharePoint sites,  each will have a dashboard generated by Power BI (source of data -> ERP: Vista from Viewpoint)

While testing the connectivity of Power BI Desktop using the most recent version (v 2.140.1078.0) with Microsoft SQL Server Management Studio (v18.12.1), I encountered issues and was having an encryption support message (server name provided does match the SQL Server SSL certificate).

When I downgraded Power BI Desktop to v 2.102.845, it does works.

Note: the most recent version of Microsoft SQL Server Management Studio (v 20.2) did not connect with our Server (SQL Server version 13.0.6455.2), this is why I use Microsoft SQL Server Management Studio v18.12.1.

I would like to make sure of the database compatibility going forward, allowing VPN connectivity and ensure that the data source setup is not altered with future version updates.

Which version of both Power BI Desktop and Microsoft SQL Server Management Studio would you recommend to ensure a flowless development?

Should we also consider updating the SQL Server version? If so, to which one?

Thanks in advance for your support,

David

Windows Server Remote and virtual desktops Session connectivity

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-26T08:05:20+00:00

    Hello DavidMo6，

    Thank you for posting in Microsoft Community forum.  

    From the description above, I understand your question is related to SQL Server.   

    Since there are no engineers dedicated to SQL Server in this forum. To be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.  

    Here is the link for Q&A forum: 

    Questions - Microsoft Q&A 

    Note：

    Windows Client for IT Pros and Windows Server forums are moving to Microsoft Q&A

    We’re transitioning to Microsoft Q&A for a more streamlined experience. Starting February 26th, new questions can only be posted on Microsoft Q&A. Existing discussions will remain accessible here. 

    Beginning March 3rd customers looking for support on Answers will be automatically redirected to Microsoft Q&A.

    Regards,

    Haijian

    0 comments
  2. Anonymous
    2025-02-26T23:38:58+00:00

    Thank you very much Haijian

    0 comments