Forum Discussion

emutuc's avatar
emutuc
Frequent Visitor
1 year ago

Problem with Auto Refresh - SQL Server

I am having issues getting Power BI to automatically refresh. I'd like to send out daily reports with the latest data. I get the following error:   Failure details: The last refresh attempt failed...
Need Help
  • emutuc's avatar
    emutuc
    Frequent Visitor
    1 year ago

    Many thanks@rajendraongole1 for your help.  I changed to "not encrypted" and still get the same error

     

     

    • emutuc's avatar
      emutuc
      Frequent Visitor
      1 year ago

      hello rajendraongole1 do you have any more suggestions.  This is the error message I get 

       

      Data source error: The MySql source doesn't support encrypted connections. (Source at 144.208.70.101;nexusb8_app_insights.). The exception was raised by the IDbCommand interface. Table: Query1.
      Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
      Activity ID: b6dc4973-e78c-4b64-a9c5-26c354d75762
      Request ID: a68e39de-5ba2-463b-bc32-30ac2eb530a4
      Time: 2025-03-19 17:24:07Z

      • rajendraongole1's avatar
        rajendraongole1
        Super User
        1 year ago

        Hi emutuc  - can you run the command in mysql

        SHOW VARIABLES LIKE 'require_secure_transport';

        If it returns ON, the server requires SSL, and Power BI won't connect without an encrypted session.
        If it returns OFF, unencrypted connections are allowed.

        disabled it by using below command, if it is turn on.

        SET GLOBAL require_secure_transport = OFF;

         

        check the mysql version also, if you are using older it may not support to fetch via power bi. 

         

        Hope this helps.