MySQL Connector - Direct Query

Hi Sandy_22​,
Thanks for reaching out to the Microsoft Fabric Community forum.

According to Microsoft's documentation, the MySQL database connector supports Import mode. Under Capabilities supported, the connector lists Import and several advanced options, but DirectQuery is not listed.

Microsoft's Use DirectQuery in Power BI Desktop documentation states that to determine whether a data source supports DirectQuery, you should check the connector's Capabilities supported section. If DirectQuery isn't listed there, DirectQuery isn't supported for that data connector.

Therefore, when using the native MySQL database connector, the DirectQuery connectivity option isn't available, and the connection uses Import mode.

For more details, please refer to the below official Microsoft documentation:

Power Query MySQL database connector - Power Query | Microsoft Learn

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

Power BI data sources - Power BI | Microsoft Learn

I hope this helps. Please feel free to reach out if you have any further questions.
Thank you.