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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Data Model can't be refreshed

One of our Data Models was corrupted for an unknown reason.
We starting the updates with help of pipelines in ADF(Pipeline RunID for one of the cases: 746631d5-949b-4d36-aad0-bbd1f9e6f6b1)
Starting from the 2nd of January we stuck with an issue:
Power BI side:
02.2023:

Data source error:Retry attempts for failures while executing the refresh exceeded the retry limit set on the request.
Request ID:f856808a-d669-4ec5-a5a5-d2228202bcc2
Time:1/2/2023, 08:27:39


03.2023:

Data source error:Retry attempts for failures while executing the refresh exceeded the retry limit set on the request.
Request ID:c21f6a59-3279-4753-9bc1-2ecf69bda473
Time:1/3/2023, 09:42:37


ADF side:
Error message from ADF:
"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set on the request.","type":"Error"},{"code":"0xC1020001","message":"The following error occurred while opening the file <ccon>\\\\?\\D:\\PF\\pbipnortheuropepf15\\data\\AS\\62\\431\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0.2.db\\9046d56c df61 469c b5ab c27fd0359d3b (97).rel\\180.R$Fact Event (43)$9046d56c df61 469c b5ab c27fd0359d3b (97).hidx</ccon>.","type":"Error"},{"code":"0xC1020001","message":"The following error occurred while opening the file <ccon>\\\\?\\D:\\PF\\pbipnortheuropepf15\\data\\AS\\62\\431\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0.2.db\\1f3fcac2 5deb 48b7 92a6 b01ccb637123 (96).rel\\180.R$Fact Event (43)$1f3fcac2 5deb 48b7 92a6 b01ccb637123 (96).hidx</ccon>.","type":"Error"},{"code":"0xC1020001","message":"The following error occurred while opening the file <ccon>\\\\?\\D:\\PF\\pbipnortheuropepf15\\data\\AS\\62\\431\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0.2.db\\301c1652 c3ab 4be7 ad0e da69846aad7b (294814).rel\\180.R$Fact Count (40)$301c1652 c3ab 4be7 ad0e da69846aad7b (294814).hidx</ccon>.","type":"Error"},{"code":"0xC1020001","message":"The following error occurred while opening the file <ccon>\\\\?\\D:\\PF\\pbipnortheuropepf15\\data\\AS\\62\\431\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0.2.db\\b6fedd71 77e4 4ba2 bfc9 6968c9f42e41 (294822).rel\\180.R$Fact Anomaly (37)$b6fedd71 77e4 4ba2 bfc9 6968c9f42e41 (294822).hidx</ccon>.","type":"Error"},{"code":"0xC1020001","message":"The following error occurred while opening the file <ccon>\\\\?\\D:\\PF\\pbipnortheuropepf15\\data\\AS\\62\\431\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0.2.db\\02edd586 acd3 406f aef5 549455da79f6 (294823).rel\\180.R$Fact Anomaly (37)$02edd586 acd3 406f aef5 549455da79f6 (294823).hidx</ccon>.","type":"Error"},{"code":"0xC1020001","message":"The following error occurred while opening the file <ccon>\\\\?\\D:\\PF\\pbipnortheuropepf15\\data\\AS\\62\\431\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0\\22b6fb3b-b75b-4b23-84a1-1bd6b810c3b0.2.db\\f51d0c31 583f 46f7 a0b4 6bd9205dae70 (294833).rel\\180.R$Fact Count (40)$f51d0c31 583f 46f7 a0b4 6bd9205dae70 (294833).hidx</ccon>.","type":"Error"},{"code":"0xC136010A","message":"An error occurred while parallel loading Vertipaq data objects for multiple relationships","type":"Error"


Status: Investigating
Comments
Anonymous
Not applicable

Hi @Anonymous ,

 

For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits datasets on shared capacity to eight daily dataset refreshes. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings.

 

You may use the schedule view to determine whether the scheduled refresh events are properly spaced. To understand the maximum number of concurrent refreshes allowed per SKU, review the Capacities and SKUs table.

Or please try modify your refresh schedule to perform the refresh operation when fewer datasets are being processed. You can also increase the time between refresh operations for all datasets in your refresh schedule on the affected Premium capacity. You can retry the operation if you're using custom XMLA operations.

 

For more information,you may aslo refer to :

Solved: Refresh error (refresh limit exceeded) - Microsoft Power BI Community

Solved: Re: Retry attempts for failures while executing th... - Microsoft Power BI Community

 

Best regards.
Community Support Team_ Caitlyn

 

Anonymous
Not applicable

Dear @Anonymous ,

It worked without issues for a month, after that it was somehow corrupted.

We deleted the dataset, upload it again and the update started work without issues.
Currently, I want to know the reason for corruption.

Best regards,
Pavel Tseitlin.