Forum Discussion
MySQL Connector - Direct Query
Hi Team,
From Power BI, I'm using the MySQL connector to connect to the MySQL database. However, I do not see an option to choose the data connectivity mode as DirectQuery. The connector is automatically using Import mode.
When I checked the Microsoft documentation, it appears that the MySQL connector is supported only in Import mode.
Could you please confirm whether this is expected behavior? Is it true that Power BI does not support DirectQuery connectivity with MySQL using the native MySQL connector?
Thanks in advance!
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.
5 Replies
Hi Sandy_22,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to MFelix for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hi Sandy_22,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank youHi 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.Hi Sandy_22,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
