Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

near Real time data refresh & composite models

Hi my database is Mysql and therefore does not support DirectQuery. I'm currently working in Import mode and the main table is made of +3M rows so it takes a while to refresh it. This table is conta...
Need Help
nadavsn's avatar
nadavsn
Advocate I
7 years ago

I am having the same issue. 

I will update if I get a solution. 

 

nadavsn's avatar
nadavsn
Advocate I
6 years ago

Hi all

I finish my POC with the CData connector to MySQL. https://www.cdata.com/drivers/mysql/powerbi/ 

We had some problems and bugs at the beginning, but the last version does work.

I successfully connected to MySQL DB via desktop and gateway in direct-query mode.

It required buying a license, of course, but it is a working solution. 

I hope this helped.

Nadav