Forum Discussion
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: {"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
6 Replies
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".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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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-Lag0VOiTsYou 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=mGnNn6gnrKkThanks amitchandak , I will do what you tell me and then I will come back with an answer
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
