Forum Discussion
MySQL Direct Query
Hi Team,
I have azure mysql and required to connect power bi using direct query, i have seen the documents mysql doesnt support direct query. is there any alteranive way or connector i can use to connect mysql live, please advice
HI mohamedm ,
Sorry but currently my sql is only supported in import mode.
Here is the reference. https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources
Best Regards,
Lucien
3 Replies
mohamedm , Live will only mean import in pbix and then use dataset. I doubt there is way if not supported to have direct query
Thanks alernativly im looking can we run a script to publish from Desktop ? or use any 3rd party connectors
HI mohamedm ,
Sorry but currently my sql is only supported in import mode.
Here is the reference. https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources
Best Regards,
Lucien
