Direct Query mySQL

[PBE]

Hi

Is it possible to direct query mySQL from Power BI in the same way as you can from MS SQL.

Making it possible to have near live data in a report as opposed to only updating when an import happens.

Looking at different posts it seems historically it wasn't possible but I can't find a definitive recent answer.

PB

[lbendlin]

There are custom connectors that claim to achieve that via  ODBC.

Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn

[ajaybabuinturi · Accepted solution]

Hi @PBE,

Wanted to let you know that Power BI does not support DirectQuery mode for MySQL. DirectQuery is only officially supported for a limited set of sources (like SQL Server, Azure SQL, Snowflake, Databricks, etc.).


More info about Direct Query: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about?utm_source=chatgpt... 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.