Dataflow Gen 2 - Microsoft Power BI REST API

[SELECTDBA]

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!

[Anonymous]

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]

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.