Forum Discussion

admin_jwf's avatar
admin_jwf
New Member
5 years ago

Dataset won't refresh

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: {"er...
General Comment
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

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's avatar
admin_jwf
New Member
5 years ago

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's avatar
    v-yingjl
    Community Support
    5 years ago

    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.