Hello all,
I am using Moodle Workplace and am trying to get some more detailed reports than the in-Moodle report builder can provider, which I can automate and have update regularly in a Business Intelligence software. Our Moodle provider company opened a MySQL server which sits in MySQL workbench but we were unable to connect to Power BI. We then tried a third party data warehouse company but have also been unable to connect the data source.
I am aware that Moodle does not have a native power bi connector and I shall keep trying to connect our MySQL database to Power BI, but was wondering if anyone has any suggestions for pulling data out of Moodle and into a Business Intelligence or data visualisation software? Preferably something that would update on a regular, automated basis.
Thanks all!