Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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:
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.
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
This is all being done on Linux. So, no Power BI Desktop.
Also, I am using Blob storage, no Cosmos DB.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |