Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
corbett3442
Frequent Visitor

Gen 2 Dataflow with Function inside will not publish

I have some helper queries, including a function, and everything inside the dataflow appears to be working correctly.  I turned enable staging off on every other query except the final one.  I don't yet even have it pointing to any destination.  

 

When I try to run it, I get this error:

 

Snag_583374d.png

 

Any idea what the issue could be?  I suspect it is the function but like I said, no visible errors within the dataflow.

 

Thanks

1 ACCEPTED SOLUTION
v-pnaroju-msft
Community Support
Community Support

Hi @corbett3442,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Kindly follow the troubleshooting steps below, which may help resolve the issue:

  1. The error appears to indicate a problem with dataflow evaluation. The unknown evaluation error code 104100 is generally associated with an issue in the underlying M code, particularly when a function is involved.
  2. Open the function in the Power Query Editor and ensure that there are no syntax errors or parameter-related issues. Create a new query that invokes the function with sample parameters to verify whether it executes correctly outside the dataflow context.
  3. Ensure that only the final queries have staging enabled. Check whether any helper queries depend on each other’s outputs, and confirm that they execute in the correct sequence. Preview the results of each query within the dataflow to identify any specific part returning unexpected results or errors.
  4. Utilise Microsoft Fabric’s built-in diagnostic tools to gain insights into dataflow performance and potential issues. You may access the logs through the Power Query Editor for more detailed information regarding the error.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

View solution in original post

4 REPLIES 4
v-pnaroju-msft
Community Support
Community Support

Hi corbett3442,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

v-pnaroju-msft
Community Support
Community Support

Hi corbett3442,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

v-pnaroju-msft
Community Support
Community Support

Hi corbett3442,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

v-pnaroju-msft
Community Support
Community Support

Hi @corbett3442,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Kindly follow the troubleshooting steps below, which may help resolve the issue:

  1. The error appears to indicate a problem with dataflow evaluation. The unknown evaluation error code 104100 is generally associated with an issue in the underlying M code, particularly when a function is involved.
  2. Open the function in the Power Query Editor and ensure that there are no syntax errors or parameter-related issues. Create a new query that invokes the function with sample parameters to verify whether it executes correctly outside the dataflow context.
  3. Ensure that only the final queries have staging enabled. Check whether any helper queries depend on each other’s outputs, and confirm that they execute in the correct sequence. Preview the results of each query within the dataflow to identify any specific part returning unexpected results or errors.
  4. Utilise Microsoft Fabric’s built-in diagnostic tools to gain insights into dataflow performance and potential issues. You may access the logs through the Power Query Editor for more detailed information regarding the error.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.