Forum Discussion

Indrasena's avatar
Indrasena
Regular Visitor
4 years ago

Connecting from power BI to rest API with Oath2 authentication

Can someone provide a sample power bi project for connecting power Bi to rest API using Oath2 authorisation.  
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Indrasena 

 

If you want to connect from Power BI to a REST API that uses OAuth2 authentication then you need to build a custom connector. You can find documentation on how to implement an OAuth2 flow in a custom connector here.

For reference: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GavinJolly's avatar
GavinJolly
New Member
4 years ago

I have tried building one but am not a developer and it is quite frustrating. Can someone just build one and publish it? I know there is an issue that PowerBI cannot deal with Secrets.

 

This person has built one for OuraCloud, can someone do the same for AzureAD.

 

Here was my stumbling path BEFORE I even got to developing, where once again, I realise I am not a developer. This was over 2 hours of just plain annoying documentation from Microsoft.

 

  1. View Power Query SDK page - Need Visual Studio
  2. Install Visual Studio - 2022 Community
  3. FAIL Power Query SDK will not install
  4. Research - PQ SDK only supports VS 2019
  5. Install Visual Studio - 2019 Community
  6. FAIL Cannot create project - Missing File
  7. Research - Need any workflow - Apparently according to one page
  8. Install Python extension - Smallest
  9. FAIL - Cannot create Project - Something something Folder, Roslyn
  10. Install another extension, .NET, C# and others
  11.  SUCCESS: Can now create a new Connection project

 

Maybe the SDK page could say "Does not support 2022 - Install older VS version" and list what is needed to actually MAKE A **bleep** PROJECT.