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 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
I have a pretty simple Power BI dataset with 4 queries.
The first query retrieves an access_token from an API:
= () => let
url = "https://api./.../application",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([applicationId = 123, applicationSecret = "123"]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
access_token = Json.Document(response)[accessToken]
in
access_token
The other queries use the dynamically generated access token and retrieve data from the API:
let
Source = Json.Document(Web.Contents("https://api./...", [Headers=[token=GetToken()]])),
# ...
# ...
in
# ...
It all works fine and I can refresh the data if I click "Refresh" in the dataset in the Power BI desktop application.
What I want to do though is to publish the dataset to Power BI service and schedule a refresh.
In order to do so I need to edit the credentials somehow:
What do I need to do here in order to regularily configure a Scheduled Refresh?
Thank you
Update:
If I try and establish the data connection to the Web API without a dynamic token that uses a POST request to get the token for the API, meaning by getting a token value in Python by using the POST request and putting it into the data connection pane:
This works fine after publishing it to Power BI Service and clicking on "Refresh Now" -> No Error.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 28 | |
| 23 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 44 | |
| 31 | |
| 17 | |
| 17 | |
| 15 |