cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vishayv
Frequent Visitor

Power BI online scheduled refresh failures

we started seeing continuous failures on one of our reports over the weekend. This is happening only for one of our Datasets.  

 

Error 1

 

Microsoft SQL: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded.

 

If you contact support for this issue, please provide them with the following information:
Activity Id: 922cabda-a988-4c0d-b891-615aafa9f3e9
Request Id: 170743fb-b6a5-48f4-8ee6-765cfff4c81f
Cluster Name: DF-MSIT-SCUS-redirect.analysis.windows.net
Refresh Start Time: 02/06/2017 02:37:06Z
Refresh End Time: 02/06/2017 04:05:07Z

 

Error 2

 

Processing error:
We're sorry, an error occurred during evaluation.
Cluster URI:
DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:
4d506b05-7edc-475c-bd7a-5d507ab64419
Request ID:
a77a8cce-e2b4-44bd-a91c-9184e0919302
Time:
2017-02-06 04:42:26Z

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @vishayv,

 

Can you share some detail content of your issue? It is hard to troubleshooting from current description. e.g. refresh history, error log, screenshots...


Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

These are the details of the last error ( below the images )  : i have also attached screenshots of refresh history etc. Let me know if there is more information you need to help debug this. This is only happening with one of our reports and this has been going on for more than a week.  

Refresh historyRefresh historyThe Scheduled refresh are disabledThe Scheduled refresh are disabled


‎2‎/‎7‎/‎2017‎ ‎9‎:‎06‎:‎22‎ ‎PM
‎2‎/‎7‎/‎2017‎ ‎10‎:‎04‎:‎57‎ ‎PM
Failed
There was an error when processing the data in the dataset.
Data source type:
SQL
Processing error:
Microsoft SQL: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded.
Cluster URI:
DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:
64dd6a1e-81df-4337-ae1e-4a841a30b23d
Request ID:
619d3802-6358-46c8-adbd-e2c42033a550
Time:
2017-02-08 06:04:57Z

Hi @vishayv,

 

Sorry for slow response. Based on your information, I think the issue is more related to server part, you can use sql profiler to trace the refresh operations and share us the detail error log.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors