Add oauth(2) as an option to authenticate for e.g. web.contents.
138 Comments
- nishalitNew MemberThis is enabled via Custom Connectors: https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconnectors
- bjoern_sjutNew MemberTo allow us to use the web.contents function more effectively, support for oauth(2) authentication should be added. Then a lot of 3rd party APIs could be queried without putting a server in the middle.
- abaconsup
Advocate I
I agree, for example I've been trying to connect Power BI to FreeAgent's Oauth 2.0 API to no avail. Support for Oauth 2 would make Power BI mightily powerful. - angryanalyticsNew Memberfor enterprise api connectivity, this is a must have. As mentioned, 1000s of apis could be opened up without having to have specific connectors for each.
- boyxx001New MemberI'm surprised this idea was proposed sooner! Oath2 support would be instrumental in gaining even more ground on Tableau. A must! Needs it!
- fbcideas_migusrNew MemberTotally agree. Went to try and use OpenPath.org (as demoed at this year's PASS BA conference) and got hit by OAUTH2 needs. I don't have the expertise to build my own API handler to do this. Would love to be able to just feed the credentials into Power Query and have it handle the authentication portion.
- g_rouxNew MemberI want it !!!!
- phylipeNew MemberYeah, I really need it too.
- sergey_ozhiganoNew MemberОчень нужно!
- nathangraham
Advocate I
Yes, please
Recent ideas
New Advanced Editor hides query name and locks editor window
Classic Power Query 'Advanced editor' opens as a separate movable, resizable window with the query name as its title. One could drag and keep the main editor visible : queries pane, applied steps, d...Mardurolla10 hours agoRegular VisitorNew9Views0likes0CommentsGet Secret from Azure Key Vault using Fabric Workspace Identity
Users can access key vault secrets using notebookutils.credentials.getSecret. This is based purely on the user's access (or object owner's access, if the notebook is being run in a pipeline). In larg...sean_cochran10 hours agoResolver INew3.1KViews14likes3CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...lamogiro11 hours agoNew MemberNew9Views0likes0CommentsPaginated Reports with PowerQuery - Cloud connections for Snowflake connector
Current situation: Power BI report builder used to build a report using Power Query dataset. Report builder picked the right cloud snowflake DB connection (created in Power BI service portal - app...jarjis_nbcu11 hours agoNew MemberNew2Views0likes0CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...Mardurolla11 hours agoRegular VisitorNew9Views0likes0Comments