Updating your PowerBi connection string to SSL

Updating your PowerBi connection string to SSL

We are transitioning to SSL-only connections for all our PowerBI integrations.  This encryption protocol ensures that data transferred between your systems and our services is secure and inaccessible to eavesdroppers. Please ensure you switch to an SSL connection by the 30th of June 2024 to maintain uninterrupted access to our services.


Currently Both SSL and Non SSL connections are allowed but from the 30th of June only SSL connections will be allowed.  We recommend making the change asap.

Below are the steps to enable data transfer over SSL for PowerBi integration between SyncEzy database and PowerBi application:
  • Open PowerBi report for specific integration.
  • If SSL is not enabled in connection string and data sync is tried then below error will be encountered in PowerBi


  • click on "File" from top menu bar > click on "Options and settings" > open "Data source settings".


  • Now click on "Change Source .." at the bottom


  • add ";sslmode=require" in connection string at the end and click on "OK" button.



Steps to update password in existing PowerBi connection:

  • Click on "Edit Permissions ..." in Data source settings


  • Click on the "Edit" button in credentials sections


  • Copy new password from SyncEzy portal, paste in password input box and click on save button.




Notes

Password and SSL both can be updated at once.


    • Related Articles

    • Connect Securely to Your Data with SyncEzy's PowerBI Integrations: using SSL Connections

      In our continuous effort to provide robust and secure data access solutions, SyncEzy is thrilled to announce the introduction of SSL (Secure Sockets Layer) connections for our PowerBI integrations. As part of our commitment to ensuring the highest ...

    • simPRO - PowerBI Setup Documentation

      Introduction Below is a guide on how to connect your SimPRO account to PowerBI or any other BI tool through SyncEzy’s server. Note: SyncEzy has a template PBIX file available. You will need a subscription to the SimPRO-PowerBI Service on ...

    • KeyPay to PowerBI (One-Way) Integration FAQs

      This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com. General Questions How often does the sync run? The sync runs every night ...

    • Introducing Password Regeneration for PowerBI Integrations

      Enhancing Data Security: Introducing Password Regeneration for PowerBI Integrations In the digital age, ensuring the security of customer data is paramount for any organization. With cyber threats evolving constantly, proactive measures are essential ...

    • PropertyMe to PowerBI (One-way) Integration Overview

      Summary This guide will give a detailed overview of every section and tab that you can find in your PropertyMe to PowerBI integration. Details PropertyMe-Username This is the email associated with the PropertyMe account you connected to get the ...