Forum Discussion
How to get the data
Hi Everyone
am try that way but this is not suitable on that. so am choosing to ssas connection. Am having 7 core data in datasource. then day to day adding 40000 rows. so i could not import the data. my data source is mysql.mysql is only available for import connection. once import on that data it occupy more memory in that power bi. am choosing to ssas connection. but how to connect mysql to ssas.
Hi Anonymous,
Do you mind using ODBC driver to get data from MySQL? It seems like ODBC direct can be work wiht the direct query connection mode.
DirectQuery DataDirect ODBC drivers in Power BI
MySQL Connector/ODBC Developer Guide - MySQL
Regards,
Xiaoxin Sheng
- Anonymous5 years agoNot applicable
HI
Am trying to this datadirect odbc driver. but am getting this type of error. so how to solved it ?.- Anonymous5 years agoNot applicable
Hi Anonymous,
I think you need to check the hostname and port number to confirm if they configued correctly. BTW, please also check the corresponding firewall port and policy setting if they blocked the request.
Regards,
Xiaoxin Sheng