Not able to import data from PowerBI Service dynamically

[mcaraballo]

Hi All!

I want to import data from the Power BI service (for example, a list of the different workspace names, a list of reports in a specific workspace, etc). 

As an example, I use this API (Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs) to obtain a list of reports in a specific workspace. I click on the "Try it" button, I sign in, enter the group id and hit the run button. Everything works fine, but the problem is that the token expires after one or two hours.

Is there a way to obtain a dynamic token? Does anyone know if there is a workaround in order to use these APIs ?

Thanks in advance!

[lbendlin · Accepted solution]

This custom connector uses AAD auth and can successfully refresh on  the service.

GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector fo...