Connecting Microsoft Graph Education API to Power BI

Question

With the deprecation of Insights for leaders in Microsoft SDS and Teams, a need has arisen to connect to the Microsoft Graph Education API for data collection to build a Power BI dashboard.

Is there a reliable method for establishing this connection, considering that the OData connector in Power BI will be retired soon?

Answer 1

Hi @Mohamed Lotfy,
Yes, there is a reliable method for establishing a connection to the Microsoft Graph Education API for data collection in Power BI, even with the retirement of the OData connector. You can use the Power BI Web connector to fetch data from the Microsoft Graph API.

Reference Document-
1.https://learn.microsoft.com/en-us/graph/api/resources/education-overview?view=graph-rest-1.0
2.https://community.fabric.microsoft.com/t5/Desktop/How-to-connect-API-to-power-bi-can-any-one-suggest-me-sample-API/td-p/2391576#:~:text=Click%20on%20the%20%E2%80%9CGet%20Data%E2%80%9D%20button%20and%20select,which%20returns%20the%20data%20you%20want%20to%20fetch.
3.https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-importing-and-analyzing-data-from-a-web-page