MySQL Direct Query

[mohamedm]

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  

[v-luwang-msft · Accepted solution]

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

[amitchandak]

@mohamedm , Live will only mean import in pbix and then use dataset. I doubt there is way if not supported to have direct query

[mohamedm]

Thanks alernativly im looking can we run a script to publish from Desktop ? or use any 3rd party connectors