Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi everyone. I am using Power BI Desktop and connecting to a web api that requires a bearer token for authentication. Refreshing the data right now is manual as I have to use Postman to call the token URL, get my token, and paste it into Power BI to refresh the data. The token the expire after an hour and I have to do that all over again. Is there a way I can generate the bearer token inside of Power BI when the refresh button is clicked? Or, can I use Power Automate and the Power BI API to give the report the needed token?
Solved! Go to Solution.
Hi @Fosters126 ,
Based on your description, you can try using Power Automate to get the token. set up the trigger process to use the Power BI REST API to trigger the Power Automate process before refreshing the dataset.
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn
Get Bearer Token in Power Automate Flow - Carl de Souza
How do I get a Bearer Token for Power BI API? - Microsoft Fabric (fabriconelake.com)
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Fosters126 ,
Based on your description, you can try using Power Automate to get the token. set up the trigger process to use the Power BI REST API to trigger the Power Automate process before refreshing the dataset.
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn
Get Bearer Token in Power Automate Flow - Carl de Souza
How do I get a Bearer Token for Power BI API? - Microsoft Fabric (fabriconelake.com)
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |