The MySql source doesn't support encrypted connections when using cloud connections
Hi, I'v been looking how to deal with this for quite long, hoping can get any ideas here: I connecting my sql database from colud server, in power desktop, everything works fine, including refreshing. But when it published, the refreshment does not work with this error message: The MySql source doesn't support encrypted connections. Looking back to my other old reports, I found that they were using on-premises gateway as long as the dataset published. But now, seems it will automaticlly using cloud connections in stead of on-premises gateway, and this is why the refreshing not work. But when i try to change it into on-premises, and it seems not possible. Is it possible to shut down cloud connections? Or moving this connection to gateway?
Not able to connect Power BI with MySql server
Hi all, i have power bi version 2.126.1261.0 and mysql server 8.0. I am trying to connect powerbi with mysql and getting an error. I initially thought that problem was related to mysql server so i tried to connect my sql server from dbveaver as well. I was able to do that but not with power bi. Can you help me please. been scratching my head over this for past week.
SQL Syntax Error in Power Bi while fetching Data From Diff Tables to Table - Visual
Hello Authors Please land me some help, I am getting Data from mysql server (Version 8.0) by MariaDB connector (in Direct Query) the schema is Star there and has 3 Tables and 2 connection between tables. Connection - FactTable - table2 (Many to many) FactTable - table3 (Many to One) when I try to put or see data in Table Visual I face this error when I put - Field1 from Table3 Field2 from FactTable What Should I do please Guied Thank You in AdvancePower BI, on-premises data gateway (personal mode) and MySQL - Invalid connection credentials
Hi all I'm using Power BI to fetch data from a MySQL database (running on AWS) via the on-premises data gateway (personal mode) + MySQL connector NET installed on Azure VM (running on Windows Server 2022). On power BI (app.powerbi.com), the gateway is up and running but when I configure the data source credentials (with parameters server, database, authentication method - basic, username, password, tried encyption on and off for MySQL database) I get the following error: Unable to update connection credentials. Invalid connection credentials. Details: : The credentials provided for the MySql source are invalid. (Source at ***********.) Please have this information handy if you choose to create a support ticket. Session Id: 2cf0ede6-52e0-45a7-82dc-1775f919a1ac RequestId: 10ffc280-fc69-4ebd-b6d5-a1d760716d9c Cluster URI: https://api.powerbi.com Status code: 400 Time: Fri Nov 10 2023 16:01:53 GMT+0000 (Greenwich Mean Time)Please have this information handy if you choose to create a support ticket. Session Id: 2cf0ede6-52e0-45a7-82dc-1775f919a1ac Cluster URI: https://api.powerbi.com Time: Fri Nov 10 2023 16:01:53 GMT+0000 (Greenwich Mean Time) On-premises Virtual network Interestingly, when I had the exact same setup on my Windows 10 machine (on-premises data gateway (personal mode) + MySQL Connector Net) talking to same MySQL database on AWS mentioned above, everything worked fine. Could someone please help? Many thanks.
scheduled refresh error
i have a report with a mysql connection in import mode on power bi desktop i publish my report on power bi server but i have a problem during scheduled refresh. error message in picture please note that i'm using older versions of power bi desktop (january 2020) and power bi server (january 2020) I'd like to solve this problem without having to update.
