Have A Problem When Refresh Dataset in PBI Premium

[18520148]

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.

[Anonymous · Accepted solution]

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.

[Shahfaisal]

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/...