cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Expression.Error: There were too many elements in the enumeration to complete the operation. Details

Hello. I have json files from Azure Blob Storage as a data source. In the files there are energy consumption values. I would like to only graph the power consumption over time. For this reason I deleted all the other values and ended up with this table:

 

Name                                       Value

power_mw0
timestamp2019-04-24T11:34:26.472475
power_mw0
timestamp2019-04-24T11:34:41.602568
power_mw0
timestamp2019-04-24T11:34:56.377102
power_mw0
timestamp2019-04-24T11:35:11.332657
power_mw1843
timestamp2019-04-24T11:35:26.430702
power_mw1762
timestamp2019-04-24T11:35:41.381805
power_mw1787
timestamp2019-04-24T11:35:56.333847
power_mw4112
timestamp2019-04-24T11:36:11.303751
power_mw1596
timestamp2019-04-24T11:36:26.403370
power_mw2048
timestamp2019-04-24T11:36:41.496519
power_mw1630
timestamp2019-04-24T11:36:56.302972
power_mw0
timestamp2019-04-24T11:37:11.417660
power_mw0
timestamp2019-04-24T11:37:26.375462
power_mw0
timestamp2019-04-24T11:37:41.471550

 

 

Since I only want to graph the power over time, I though I need to end up with a table with only two columns  (one for the timestamp and one for the power). I used the function "pivot column" and I selected "don't aggregate". This is the error I get. Can anyone please help? I am new to this. 

 

Expression.Error: There were too many elements in the enumeration to complete the operation.
Details:
    List

               

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Expression.Error: There were too many elements in the enumeration to complete the operation. Det

Hi @Anonymous 

1.Keep the "Name" and "Value" columns in the sort order as your screenshot, then create a index column from 1

2. click on "Name", used the function "pivot column" and I selected "don't aggregate" for "Value" column

6.png

3. fill up for "timestamp", fill down for "power_mw"

7.png

4.remove index column, 

then click on "power_mw" and "timestamp" columns, remove duplicates columns,

reoder columns-drag column "timestamp" from right to left

8.png

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors