For example, I use this link http:xxxx.xxxx//appCore/index.php?modname=report&op=show_results&idrep=115&dl=csv, but it doesn't work, it gave me an xml instead.
Anyone has tried this, and if yes, can you share the method?
Take a look through MySQL Dashboard, or PHPMyAdmin. If you need the SQL written then I'm happy to help, PM me.
Tried to hook Google Data Studio through to MySQL but the database query is slow and problematic, so it'll timeout before you get anything worthwhile back.
I'm working on a similar project at present.