This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hi,
I have a report with Cosmos as data source. After some data of Cosmos change, I want to force a refresh for PBI report updates.
Post
https://api.powerbi.com/v1.0/myorg/groups/{{groupId}}/datasets/{{datasetId}}/refreshes
it returns 202.
while by
GET
https://api.powerbi.com/v1.0/myorg/groups/{{groupId}}/datasets/{{datasetId}}/refreshes
the history tells the error below:
{
"id": 225716337,
"refreshType": "ViaApi",
"startTime": "2019-10-14T08:48:15.39Z",
"endTime": "2019-10-14T08:48:15.453Z",
"serviceExceptionJson": "{\"errorCode\":\"ModelRefreshFailed_CredentialsNotSpecified\"}",
"status": "Failed",
"requestId": "65b98616-85fd-4535-a978-d9ff2ca9764c"
}The token is prcoceeded by the steps:
1. get openId token by
https://login.microsoftonline.com/common/oauth2/token
payload:
headers:
{
Authorization: 'Bearer {{openid token}}
}form:
{ client_id: '{{my client id}}',
scope: 'openid',
resource: 'https://analysis.windows.net/powerbi/api',
username: '{{my account name}}',
password: '{{my password}}',
grant_type: 'password'
}2. get access token of dataset:
https://api.powerbi.com/v1.0/myorg/groups/{{groupId}}/datasets/{{datasetId}}/GenerateToken
header:
headers:
{
Authorization: 'Bearer {{openid token}}
}Could you check what I missed? Thank you!
Solved! Go to Solution.
I figured out myself. It is because the Cosmos key was input with desktop PowerBI only. While Refresh API will take advantage of PowerBI on-line (https://app.powerbi.com/), which has not key input. After providing it, Refresh API started to run, though not sure it can succeed finally. Will see
For anybody else that runs into this issue, here is a visual guide on where to enter the credential information to eliminate this error.
I figured out myself. It is because the Cosmos key was input with desktop PowerBI only. While Refresh API will take advantage of PowerBI on-line (https://app.powerbi.com/), which has not key input. After providing it, Refresh API started to run, though not sure it can succeed finally. Will see
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |