Forum Discussion
Have A Problem When Refresh Dataset in PBI Premium
Hello Everyone,
I have a struggle like that when I try to refresh my dataset on Service. Do you have any ideas to fix it?
I used the personal gateway and I believed all the datasources from the server in the script is correct.
Hi 18520148 ,
Based on an internal search, the following information emerged:
Processing for database 4c652630-54f8-42f3-a32c-5e418be6f2da with max parallelism 6 failed because of amo exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server.
Is there a lot of Schedule refreshes in a certain period of time, and there is a queue phenomenon, reaching the refresh parallel limit?
Please set schedule refresh for different datasets at different times, and make sure that you are using the latest version of gateway.Please make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#how-capacities-function
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
ShahfaisalSolution Sage
Open your model in Power BI desktop and go through all the steps one by one in Power Query. There should be a step in the list that is causing it.
See a similar post here - https://community.powerbi.com/t5/Desktop/Expression-Error-A-cyclic-reference-was-encountered-during/m-p/2392448
Hi 18520148 ,
Based on an internal search, the following information emerged:
Processing for database 4c652630-54f8-42f3-a32c-5e418be6f2da with max parallelism 6 failed because of amo exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server.
Is there a lot of Schedule refreshes in a certain period of time, and there is a queue phenomenon, reaching the refresh parallel limit?
Please set schedule refresh for different datasets at different times, and make sure that you are using the latest version of gateway.Please make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#how-capacities-function
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.