Pivot related error

[rdnguyen]

Hi all,

I tried different way and cannot get through this error message:

Error: Expression.Error: There weren't enough elements in the enumeration to complete the operation. {error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue IValue& value String& errorMessage)#(cr)#(lf)Record"}. RootActivityId = c8095f03-967e-4b22-8d75-b1956ac25171.Param1 = Expression.Error: There weren't enough elements in the enumeration to complete the operation. {error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue IValue& value String& errorMessage)#(cr)#(lf)Record"} Request ID: eb004ba7-6527-da1d-85ed-ce55a152c83b.

Sample data is as following

ID     Test      Value

A      T1         1%

A      T2         2.1  

B      T2         3.2

B      T3         Pass

Then I pivoted to get

ID    T1     T2     T3

A     1%    2.1    null

B      null   3.2    Pass

From the Power Query Editor, everything look fine, but error arose at the refresh. I wonder if you experienced this, how do you get through with a sufficient solution.

Thanks

[rdnguyen]

Hi @Daryl-Lynch-Bzy ,

The error occured at Power BI Service level, only at refresh stage. Total row count is about 32,000 rows before pivoting, data source is another power BI dataflow. If pivoting successfully, the number of columns maximumly generated is 42.

I recently moved that pivoting part to SQL to avoid complication. Pivoting within Power Query seems nice but I just cannot understand the error message to troubleshoot it.

Thanks.

[Daryl-Lynch-Bzy]

Hi @rdnguyen , I am wondering if you have tried the pivot transformation in Dataflow?  Note when you say refresh, I assume you mean the Power BI web service refresh and not the Power BI Desktop refresh.  If it is the later, could you have the 32-bit version of Power BI installed as there are a lot of Int32 reference in the above.  By the way, how many rows are in the "Sample Data" table and what is the Source?