Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Large Data Set causing timeout error on services despite having premium

Submitted by Anonymous on ‎05-23-2018 08:22 AM

Hi All,

 

 

I am working on a large dataset in which one fact table is having 1Billion rows. The size of data model was 750MB earlier and now after applying some performance optimization for better compression, I reduced the size of model to 216 MB. It is taking 2 hours 20 min to refresh successfully in desktop but on services it is producing timeout error after 2 hours as shown.

We are using P1 Premium capacity and I think in P1 premium refresh time limit is more than 2 hours and I think its around 4 hours.

 

Can you help me finding the reason for this and with a probable solution?

 

Error.PNG

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-jiascu-msft
Microsoft Employee
Microsoft Employee
‎05-24-2018 12:29 AM

Hi @Anonymous,

 

Yes, the time out of Premium is larger than 2 hours. Please refer to /power-bi/service-premium-large-datasets. Since you have the Pro license, I would suggest you create a support ticket here.

create ATicket

 

Best Regards,

Dale

Anonymous
Not applicable
‎05-24-2018 09:01 AM

Hi Dale,

 

Thanka for your reply. I will be raising the ticket to Microsoft for this. Can you help me with few of my queries:

1. What is the data refresh maximum limit for P1 Premium capacity. It is not clear from Microsoft documents. I could see 4 hours and somewhere I have seen 5 hours also.

2. Is there any way through which I can increase timeout limit for reports getting published on services. In desktop we can do that but in my case desktop is not producing any timeout error on refresh. It is completing fine.

 

Thanks.

 

Idea Statuses