ModelRefreshFailed_CredentialsNotSpecified for any API refresh call

cgroth — Fri, 09 Apr 2021 00:02:53 GMT

We are having an issue with the POST request to the /refreshes endpoint. This is the endpoint for telling the dataset to refresh, say, after updating the parameters, for example.

We are able to SEND the request no problem. We get a 202 'Accepted'. We expect this.

The issue arrives when we get the refresh history. We see that our last refresh fails with the following response from GET /refreshes (the endpoint that gives you the Dataset's refresh history) : ModelRefreshFailed_CredentialsNotSpecified

{ id: XXXXXXXXXX, refreshType: 'ViaApi', startTime: '2021-04-08T22:52:56.963Z', endTime: '2021-04-08T22:52:57.023Z', serviceExceptionJson: '{"errorCode":"ModelRefreshFailed_CredentialsNotSpecified"}', status: 'Failed', requestId: XXXXXXXXXXXXX' }

Through Postman and through our NodeJS server, our refresh commands are failing. In the attached image, you will see one 'Completed' refresh. That is the one we fired manually from the PowerBi-web app.

What We've Tried:

We tried editing the data source's credentials with the Blob storage Account Key. See here. Same result before and after.
We tried firing the request through the "Try it" option here. That one still fails as well. (See the below refresh history).
We also tried making sure our requests from Postman and Node were formatted correctly etc. To the best of our knowledge, they are.

The Postman and node requests are correct as we are getting only 200 and 202s.

Here is the error that shows up under Dataset/Settings about the last refresh:

Last refresh failed: Thu Apr 08 2021 17:05:55 GMT-0600 (Mountain Daylight Time)
The refresh failed for this model. Expand the technical details for more info.Hide details
Data source error: It looks like scheduled refresh failed because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources.
Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 00000000-0000-0000-0000-000000000000
Request ID: XXXXXXXXXXXXX
Time: 2021-04-08 23:05:55Z

4/8/2021, 5:05:55 PM 4/8/2021, 5:05:55 PM Failed The refresh failed for this model. Expand the technical details for more info.
4/8/2021, 5:04:31 PM 4/8/2021, 5:04:31 PM Failed The refresh failed for this model. Expand the technical details for more info.
4/8/2021, 5:02:50 PM 4/8/2021, 5:02:50 PM Failed The refresh failed for this model. Expand the technical details for more info.
On demand 4/8/2021, 5:02:10 PM 4/8/2021, 5:02:30 PM Completed (Done manually)
4/8/2021, 5:00:20 PM 4/8/2021, 5:00:20 PM Failed The refresh failed for this model. Expand the technical details for more info.
4/8/2021, 5:00:10 PM 4/8/2021, 5:00:10 PM Failed The refresh failed for this model. Expand the technical details for more info.
4/8/2021, 4:52:56 PM 4/8/2021, 4:52:57 PM Failed The refresh failed for this model. Expand the technical details for more info.

Re: ModelRefreshFailed_CredentialsNotSpecified for any API refresh call

Anonymous — Mon, 12 Apr 2021 07:28:46 GMT

Hi @cgroth ,

Whether the report can refresh in Power BI Desktop successfully? How did you create Cosmos database account? You can refer the content in the following blog to make schedule refresh for Cosmos dataset:

Publish Real-Time Cosmos DB Data to PowerBI.com

Best Regards

Re: ModelRefreshFailed_CredentialsNotSpecified for any API refresh call

cgroth — Mon, 12 Apr 2021 14:54:03 GMT

This is all being done on Linux. So, no Power BI Desktop.

Also, I am using Blob storage, no Cosmos DB.

topic Re: ModelRefreshFailed_CredentialsNotSpecified for any API refresh call in Developer

ModelRefreshFailed_CredentialsNotSpecified for any API refresh call

Re: ModelRefreshFailed_CredentialsNotSpecified for any API refresh call

Re: ModelRefreshFailed_CredentialsNotSpecified for any API refresh call