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

Error while scheduled refreshing

Hello!

 

I store my data in a Sharepoint list. My report has automatic refresh every 1 hour.

I have not made any changes to the data recently, but refreshing occasionally fails (2 times happened for the last 2 days). For example, it failed at 6 am, but refreshed at 7 am.

 

Data source error:The command has been canceled.. The exception was raised by the IDbCommand interface. Table: CMP.
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:8d84277f-593c-4689-b9ee-b7e8693cd5b6
Request ID:03dc6dec-d9ed-45f5-8a69-0a75c39a59ef
Time:2018-04-20 04:08:04Z

 

I see that the table name is mentioned, but I just cannot understand why most of the time it refreshes and some other time it does not, having the same dataset.

 

Thanks!

2 REPLIES 2
Highlighted
Resident Rockstar
Resident Rockstar

Re: Error while scheduled refreshing

Hi @Katerina_e

 

There are many factors may cause this issue, such as high density of data and low network bandwidth.

 

We need figure out the cause by the error it throwed.

 

You may have a refer to the similar thread. Hope it helpful.

 

Scheduled refresh failure message: The command has been canceled

Error refreshing: The command has been canceled.

 

If your issue occurs frequently and you need additional help, you could have a support by creating a ticket in Power BI support( if you are a Power BI Pro).

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Error while scheduled refreshing

Thanks! I will see whether I got those more frequently.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors