Forum Discussion
Dataset won't refresh
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!
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.