Dataset won't refresh

[admin_jwf]

Hello everyone, it's my first post and I'm pretty new to Power BI.
When a dataset that I have created I set it to update at a certain time I get the following error:

Error del origen de datos: {"error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted","pbi.error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted","parameters":{},"details":[],"exceptionCulprit":1}}} Table: PRD_PROYECTO_DET.
URI de clúster: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Identificador de actividad: 5006baec-1591-4601-b2de-a1acbe26addd
Identificador de la solicitud: 44b20be9-cfde-4552-b7cf-2b966d5426ab
Hora: 2020-09-09 18:27:26Z

I have other datasets using the same gateway and they are not giving me problems.

Can someone help me with this error please

[Syndicate_Admin]

Hello!!

I'm getting this message when I try to update or when automatic updates of information are performed in power BI. The information base is connected to a SharePoint. Someone knows what it is and how it is solved. Thank you

[amitchandak]

@admin_jwf , It does not seem like a gateway error. Open edit Query/data transformation mode. do you see any additional error. Any error column.

if you found one refer -

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

You can log and issue at : https://community.powerbi.com/t5/Issues/idb-p/Issues

But before that check for any gateway error too

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk

[admin_jwf]

Thanks @amitchandak , I will do what you tell me and then I will come back with an answer

[Greg_Deckler]

@admin_jwf Well, all I can get is that it has something to do with the table - 

PRD_PROYECTO_DET

Are there a lot of transformations going on with that query?

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[admin_jwf]

Hi @Greg_Deckler, yes, there are a lot of transformations in that query.

Now, what I realized is that on Power BI Desktop when I refesh and publish the report I don't get any errors.

How is that possible?

Also, I went to the gateway log and found this:

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=ValueException
InnerMessage=<pi>[Expression.Error] Se encontró una referencia cíclica durante la evaluación.</pi>
InnerToString=<pi>Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Se encontró una referencia cíclica durante la evaluación.
en Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)
en Microsoft.Mashup.Engine1.Language.Linker.AssemblyRecordValue.get_Item(Int32 index)
en Microsoft.Mashup.Engine.Ast.ExpressionToMVisitor..ctor(ITinyEngine engine, IRecordValue library)
en Microsoft.Mashup.Engine1.DataSourceReference.ExpressionBuilder.ToSource(IExpression expression)
en Microsoft.Mashup.Engine1.DataSourceReference.DataSourceLocation.FormatInvocation(String functionName, Int32 minArgs, Object[] args)
en Microsoft.Mashup.Engine1.DataSourceReference.FileDataSourceLocation.CreateFormula(String optionsJson)
en Microsoft.Data.Mashup.DataSourceReference.LocationSourceInfo.GetFormulaText(String optionsJson)
en Microsoft.Data.Mashup.DataSourceReference.GetTestConnectionFormulaText(String optionsJson)
en Microsoft.Data.Mashup.DataSourceReference.TestConnection(DataSourceSetting dataSourceSetting, String options, MashupConnectionStringBuilder builder)
en Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.GatewayDataAccessMashupUtils.DSRTestConnectionAsync(String dsrJson, MashupCredential credential, Nullable`1 activityId, Int32 testConnectionTimeout, String[] exemptions, String containerPool)
en Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<TestConnectionAsyncImpl>d__4.MoveNext()
Record</pi>

 What does "Cyclical reference found during evaluation" mean?

Thanx again!

[v-yingjl]

Hi @admin_jwf ,

"What does "Cyclical reference found during evaluation" mean?"

You might not have references the existing objects in your query correctly.

How did you transform data in this query? Could you consider sharing more details about it for further discussion? Please check the steps in the 'Applied Steps' area in Query editor to find which step is the problem.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.