Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors