Forum Discussion

SELECTDBA's avatar
SELECTDBA
Advocate I
2 years ago

Dataflow Gen 2 - Microsoft Power BI REST API

Hello; I was wondering if anyone has had any luck building a Fabric Gen 2 Dataflow to pull the Power BI Rest APIs?  I'm curious on the token exchange process, and navigating that token expiring process.  Thank you!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi SELECTDBA ,

     

    Do you want to connect to REST APIs in Dataflow Gen2 using the Web API connector provided by Data Factory in Microsoft Fabric?

    Here's an official document about this. Please kindly refer to:

    Connect to REST APIs in dataflows - Microsoft Fabric | Microsoft Learn

     

    Best Regards,

    Stephen Tao

     

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

    • SELECTDBA's avatar
      SELECTDBA
      Advocate I
      2 years ago

      Thanks, Stephen.  I did stumble onto that documentation, but I was curious more on the token exchange process.  We're pulling from the Power BI Rest API (here).  Today we use Python with the MSAL package to get the access token using a Service Principal.  That token expires after an hour, so we handle the token exchange process inside of Python.  I was wondering if anyone had already tried this portion, or if there was documentation on it.