Connecting SAGE 50 accounting to Power BI

[Kfoxcu]

I am not a developer 😞 but I am trying to connect SAGE 50 (accounting system) to Power BI

I have installed these:

• Sage50Accounts_ODBC_x64.msi

• ODBC driver 18 for SQL server

so that I can use the ODBC from Power BI, but I get the following error after I select the SAGE company I want to get the data from

Details: "ODBC: ERROR [HY000] [MySQL][ODBC 8.0(a) Driver]Can't connect to MySQL server on 'localhost:13540' (10061)

ERROR [HY000] [MySQL][ODBC 8.0(a) Driver]Can't connect to MySQL server on 'localhost:13540' (10061)"

if someone can help me understand this error so that I can find a way to fix it and successfully connect to my accounting data it would be very helpful!

Thanks,

Karen