Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When initating a data refresh for a particular dataset in the online Power BI service, the following error is returned after roughly 2 hours:
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}}],"exceptionCulprit":1}}} Table: Table1.
The data refresh for this dataset consists of 6 queries:
The Web API query for "Table1" is set for a 3-hour timeout:
Source = Json.Document(Web.Contents(url & "ticket=" & apiTicket & "&project_id=" & projectID & "&step=filter&filter_id=" & filterID & "&details=some&include=custom_field_values",
[
Headers = [#"Content-Type" = "application/json"],
Content=Text.ToBinary(""),
Timeout=#duration(0,3,0,0)
])),
In the desktop version of Power BI, the data refresh takes roughly 45 minutes and completes successfully.
Using the same queries with a smaller data source (such that "Table1" would have ~250 rows instead of ~6000), the online service refreshes successfully.
Are there settings, either in the online service or in the desktop version, that could be adjusted to prevent this timeout error?
Solved! Go to Solution.
Hi @Robert_T ,
You have touched the maximum refresh time of shared capacity. You can upgrade it to premium capacity. Or try to optimize your data source to reduce data refresh.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Robert_T ,
You have touched the maximum refresh time of shared capacity. You can upgrade it to premium capacity. Or try to optimize your data source to reduce data refresh.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @VDH ,
If it has reached "maximum refresh time of shared capacity" than why the error message doesn't clearly mentions that. Why it leaves the user with incomplete information?
Moreover, "Power BI limits datasets on shared capacity to 8 scheduled daily dataset refreshes." here user is facing issue even in the 1st attempt? It doesn't seems to be a License issue. Please explain.
BTW, I'm also facing same issue for the 1st time in past 4 years.
Hi @Robert_T,
Do you found some solution for your problem?
I have the same problem and I not find any solution.
The solution present here by Dedmon Dai, not solve in my case.
I Didn't find another solution.
Thank you for your attention.
Hey @DineiSilva, I ended up implementing a workaround whereby I broke up the dataset into multiple parts (~6) and performed separate parallel API calls for the different parts. I was not able to get the entire large dataset in a single call.
Thank you @Robert_T for your answer.
I needed change my data set, mainly the ordem of the Incremental refresh in the steps (Power Query). After this action, my issue was solve.
Thank you again.
@Robert_T , I doubt it still did not connect to database properly
in case you are using the gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/