- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
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.
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.
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
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-01-2025 10:30 PM | |||
05-04-2025 07:06 AM | |||
07-01-2024 08:54 PM | |||
03-10-2025 04:36 AM | |||
06-25-2025 01:28 AM |
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
3 |