Forum Discussion

zahirmohideen's avatar
zahirmohideen
Helper I
2 years ago

Couldn't load the data for this visual

  Hi I have a power bi report connected to MariaDB data source ( on premises ) via direct mode. The underlying data set is a view . The report stops working intermittently and resumes work...
Need Help
GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi zahirmohideen 

 

There are always a lot of challenges when working with DirectQuery. It could be an issue with the gateway, MariaDB and a combination of the visual that you are trying to use. As well as potential filters which are trying to be passed through to your MariaDB.

 

I would suggest trying with a simple visual to see if that works without having an big filters applied. If that always works then it has to do with the way the data is being interacted with.

zahirmohideen's avatar
zahirmohideen
Helper I
2 years ago

Hi GilbertQ 

 

I tried with the simple visual as well . It is so random / intermittent. I tried both direct query / import . Still the same issue . Seems to be issue with Maria DB ODBC connector forcing the view to reparse / re-prepare .

 

Filed a case with MS . Since this is a 3rd party connector . They suggested me to file a request in the GitHub for Power BI 3rd party.