Hi Kit D,
We had the same challenges since Moodle doesn't provide the native connector to integrate. But we have connected the database to the PowerBI and are able to access all the tables for analysis purposes. It gets updated as the data comes to DB.
In our environment we use DB as a separate service in the AWS and we integrate the DB with powerbi using endpoint and credentials.
We had the same challenges since Moodle doesn't provide the native connector to integrate. But we have connected the database to the PowerBI and are able to access all the tables for analysis purposes. It gets updated as the data comes to DB.
In our environment we use DB as a separate service in the AWS and we integrate the DB with powerbi using endpoint and credentials.