Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Neka
Helper III
Helper III

How to automatically generate bearer token and execute a url to retrieve a list of PBI workspaces?

Hello,

 

We are trying to use the PBI Rest API to automate the retrieval and storage of a workspace list. We need to first generate a bearer token to execute this url: https://api.powerbi.com/v1.0/myorg/admin/groups?%24top=5000 and put the results in ADLS. Can this be automated in Azure/Fabric using Azure Data Factory or some other tool? 

3 REPLIES 3
uahmed114pbi
Frequent Visitor

I had the same issue and took alot of time to try and figure it out. I created a post that lays it all out. Hope it helps!

To get Power BI API Access Token dynamically, make... - Microsoft Fabric Community

Anonymous
Not applicable

HI @Neka,

Perhaps you can take a look at the following document about generated token for rest api usage if helps:

Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

Xiaoxin Sheng

soniya-01
New Member

  1. Generate Bearer Token: It's like a special key. Go to your Power BI service, find your profile, and create an app. This app gives you the key (Bearer Token).

  2. Use a URL: Think of the URL like a request form. Craft a URL with specific details, like asking for a list of workspaces. Attach your Bearer Token to this request form.

  3. Send the Request: Imagine mailing this form. Use a programming language (like Python or JavaScript) to automatically send this URL request. The Bearer Token acts as your signature to get a response.

  4. Receive the List: Just like getting a package in the mail, your program receives a response. It contains the list of Power BI workspaces you asked for.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.