Forum Discussion
Use Microsoft Graph API as data source
The Microsoft Graph implements the OAuth 2.0 authentication flow and therefore, to access it with Power BI, you'll need to create a custom data connector. Here's a tutorial that walks step-by-step on how to create a custom data connector with OAuth 2.0 to the Microsoft Graph in Power BI.
Resolver IIThe Microsoft Graph implements the OAuth 2.0 authentication flow and therefore, to access it with Power BI, you'll need to create a custom data connector. Here's a tutorial that walks step-by-step on how to create a custom data connector with OAuth 2.0 to the Microsoft Graph in Power BI.
Thank you. I walked trough the tutorial, but stuck at the end:
"You can now build your project in Visual Studio to create a compiled extension file, and deploy it to your Custom Connectors directory. "
How does this work? I copied the "MyGraph.mez" file to "Documents\Power BI Desktop\Custom Connectors" folder changed the security settings, but still not appear as connector.
- tonmcg
That last part of the tutorial sort of hand-waves over important steps needed to get custom connectors working. After you've copied the .mez file over to your Custom Connectors folder, you'll need to lower the security level for extensions in Power BI Desktop to enable loading custom data connectors.
In Power BI Desktop:
- Go to File | Options and settings | Options
- Go the Security tab
- Under Data Extensions, select Allow any extension to load without warning or validation
- Restart Power BI Desktop
I took this from the Quickstart section of the DataConnectors GitHub repo.
Great, thank you, I found it finally, only I was waiting for the warning sign from PowerBI and didn't come up. Indeed, the connector is there and working. I still find it strange that MS doesn't provide a more simple way to access this data.
- mahoneypat
Microsoft Employee
I will be going through this tutorial to make a .mez file. Before I do that, can someone just post a generic .mez that we all could use (with our own Azure AD app credentials? Not how it works?
Regards,
Pat
mahoneypat There is a sample over here: https://github.com/microsoft/DataConnectors/tree/master/samples/MyGraph
