Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

0
suzukishm

Error: We're sorry an error occurred during evaluation

Submitted by on ‎12-28-2022 06:53 PM

An error occurred when I created an ETL in DataFlow in the Power BI Service and made an update.
I checked the update history of the corresponding DataFlow and read the output txt file, which described the following error.
```
11:44:04,00:03:00.9000,NA,NA,NA,NA,NA,NA,Error: We're sorry an error occurred during evaluation: 2cafda24-7975-1cdf-ff04-ec34029e1cbd Activity ID: 95dae3d1-6f58-4b6c-9676-df9c6046ff81
```

 

The Power Query preview in DataFlow shows the results without any problems. What should I do?

Status: Delivered
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎01-01-2023 06:12 PM

Hi @suzukishm 

Have you successfully created an ETL before? The information you provided is not enough to determine the cause of the problem. Can you provide more detailed information?

 

Best Regards,
Community Support Team _ Ailsa Tao

suzukishm
Frequent Visitor
‎01-04-2023 08:59 PM

Hi @Anonymous,

 

Thank you for providing your perspective. I agree with you that the information I have provided is limited, but this is only the information I can get from execution history of the Data Flow. コメント 2023-01-05 134133.png

It will be helpful if you let me know what types of information is required !!

 

> Have you successfully created an ETL before? 

Yes – I have had success when I executed it at first time.

suzukishm
Frequent Visitor
‎01-04-2023 10:58 PM

I solved the problem myself. As it turns out, the problem was with the Excel file itself.

 

In order to isolate if the error was occurring in any of the steps of Power Query, I deleted and run the steps one by one.
Then I noticed that the loading Excel file was failing at the stage of updating in the Power BI Service. This process have no problem at Power Query. I checked the file, and it performed a repair of the corruption. After I repaired the file, the file processing by Data Flow succeeded.

 

This means Power Query could read the corrupt file, but Data Flow could not.

Anonymous
Not applicable
‎01-04-2023 11:10 PM

Hi @suzukishm 

I am so glad to hear that you fixed your issue . Thank you for sharing your solution, it's a great help for users who have the same problem . 

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses