Forum Discussion
gflisch
May 14, 2024Copper Contributor
Capability to connect Excel to a protected OData Feed by OAuth2.
I am working in a utility company and we have some OData Feeds (build via asp.NET Core) that we expose to the business so they can consume their data and build by their own the reports they want.
As we consider security seriously, we are protecting all our service endpoints with OAuth2 and check also if the person has or not access to the data.
One of the top feature expected from the business users is to have access to their Data in a protected way via Excel/Power BI so only authorized people can see and consume them!
In Excel and Power BI, doing this is not possible (I have opened a case for that via our services hub portal) and we need votes to increase the visibility on this feature so this can be considered by the Office365 team.
Thanks in advance.
- AshaKantaSharmaIron ContributorConnecting Excel and Power BI to OData feeds protected by OAuth2 requires understanding their capabilities. To do this, use Microsoft Query (for Excel 2016 and earlier) and Power Query (for Excel 2016 and later). If OAuth2 is not supported directly in Excel, consider using an intermediary service or API gateway that handles OAuth2 authentication. Develop a custom connector that supports OAuth2 authentication and use it within Excel. For OAuth2 integration, use the Power BI Custom Data Connector SDK to build a custom connector. If native support for OAuth2 in Excel and Power BI for OData feeds is not yet fully implemented, submit feedback using the Microsoft Feedback Hub or Power BI Community forums. Engage with Microsoft Support, leverage user voice, and work with other organizations or industry groups for faster changes. When dealing with OAuth2 and sensitive data, ensure compliance with your organization's security policies, regularly review and audit access permissions, and keep track of OAuth2 standards and Microsoft's implementation.