cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
XiaodongLiang
Regular Visitor

ModelRefreshFailed_CredentialsNotSpecified when Refresh DataSet

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!

1 ACCEPTED SOLUTION
XiaodongLiang
Regular Visitor

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

View solution in original post

2 REPLIES 2
travisjones
New Member

For anybody else that runs into this issue, here is a visual guide on where to enter the credential information to eliminate this error.

 

EnterRefreshCredentials.jpg

XiaodongLiang
Regular Visitor

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.