cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jderekc Member
Member

Reports are slow to use

Has anyone else been having problems lately with the Power BI service loading some reports very slowly?  Yesterday I had two reports that, when clicking on a filter (slicer), would take several minutes to reload the data based on the filter results.  It went away but today has come back again.  Yesterday I had dataset errors that stated there was an "internal service error".  Today I have a few dataset errors that say "the gateway operation has been canceled explicitly by the user or from a timeout".

 

This is becoming a nuisance for our users.  I have already restarted the gateway on the server it is hosted on.  These datasets all connect to an internal MS SQL Server (2012).  I also updated the gateway earlier this month.  This just started happening yesterday.

 

Error Example:

 

Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:1b9917aa-dfb0-41c3-bc21-18a367199c57
Request ID:c3d52c66-ff9b-2f97-2400-20480ecc492d
Time:2017-10-30 15:49:10Z

 

On demand10/30/2017, 10:47:36 AM10/30/2017, 10:49:10 AMFailed

The last refresh attempt failed because of an internal service error.

 

Scheduled10/30/2017, 8:31:25 AM10/30/2017, 10:36:59 AMFailedThe last refresh attempt failed because of an internal service error.

 

Scheduled10/31/2017, 8:30:10 AM10/31/2017, 8:34:58 AMFailedThe gateway operation has been cancelled explicitly by the user or from a timeout.

 

Any help is appreciated.

1 REPLY 1
Highlighted
v-yulgu-msft Super Contributor
Super Contributor

Re: Reports are slow to use

Hi @jderekc,

 

Does the schedule refresh in PBI Service always fail or intermittently? Does this problem occur if you manually refresh the dataset instead of schedule refresh? Can you refresh the dataset successfully in PBI Desktop? If yes, how long will it take to complete the refresh?

 

If possible, please try to remove this dataset on PBI Service and republish it to check whether issue persists. Besides, a similar issue has been reported internally. CRI: 47607387

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 6 members 4,375 guests
Please welcome our newest community members: