Forum Discussion
Access Microsoft Graph Data
I want to build a report using Microsoft Graph API, but I have noticed this may be something Power BI cannnot access. Has anyone else had this issue?
Hi istduncan-cohp,
How are you trying to access the Microsoft Graph API data? Generally, you would require an app registration with appropriate API Permissions for accessing the Graph API.
Some of the below-mentioned blogs elaborate on the steps in detail to connect Power BI with Microsoft Graph -
- https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35
- https://techpeanuts.wordpress.com/2020/05/28/connecting-power-bi-to-microsoft-graph/
In our Organization, we are using an App Registration with Microsoft Graph API Permissions (like User.Read, Groups.Read.All, etc) for accessing the Graph API. A data factory pipeline uses this app registration to bring data into our data warehouse, which is later used as a data source in Power BI for consuming the data. You can also write scripts that use app registrations to connect to Graph and fetch and export data into CSV files, to be read later by Power BI.
Let me know if the above-mentioned suggestions help, or if you have any specific requirements.
2 Replies
Hi istduncan-cohp,
How are you trying to access the Microsoft Graph API data? Generally, you would require an app registration with appropriate API Permissions for accessing the Graph API.
Some of the below-mentioned blogs elaborate on the steps in detail to connect Power BI with Microsoft Graph -
- https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35
- https://techpeanuts.wordpress.com/2020/05/28/connecting-power-bi-to-microsoft-graph/
In our Organization, we are using an App Registration with Microsoft Graph API Permissions (like User.Read, Groups.Read.All, etc) for accessing the Graph API. A data factory pipeline uses this app registration to bring data into our data warehouse, which is later used as a data source in Power BI for consuming the data. You can also write scripts that use app registrations to connect to Graph and fetch and export data into CSV files, to be read later by Power BI.
Let me know if the above-mentioned suggestions help, or if you have any specific requirements.
Bipin-Lala We're using the app registration. Thank you this looks as though this make work.
