Troubleshooting dataflow Gen2 query

[sakBI]

Dear community, 

I'm using Power BI to get the Azure Cost data , I've been working in Dataflow Gen 1 for long and I was trying to transition to Dataflow Gen2 .

I've done two attempts in the two of them a query that I can see on the Dflow edit refreshing with content , fails on the refresh.

I've tried to recreate the connection, recreate the query and when I do so it's worse.

What surprises me most is that the Query that's failing doesn't do any transformations 

let

  Source = AzureCostManagement.Tables("Enrollment Number", "*******", 12, [startDate = null, endDate = null]),

  #"Navigation 1" = Source{[Key = "rirecommendationssingle"]}[Data]

in

  #"Navigation 1"

Can any of you suggest how to do troubleshooting ?

There was a problem refreshing the dataflow. Please review the error message(s) below, fix the problem, and try again. (Request ID: 7eea3b4a-3cc9-4b9e-afef-a7a01198f11b).

RI recommendations (shared): Error Details: We encountered an error during evaluation. Details: Unknown evaluation error code: 104100 (Request ID: 7eea3b4a-3cc9-4b9e-afef-a7a01198f11b).

On my first attempt this table was not giving issues it was a different table that suddenly stopped working.

[sakBI]

Thanks for your reply, 
As this was a new Dataflow copy of the existing one I could do tests and seems that disabling staging made those tables work.

In any case I find troubeshooting in Gen2 quite dificult and logs don't provide much information.

Latest time it failed after I had everything reviewed and spending 1 week of progress, and I had to rollback to this version.

[v-vpabbu · Accepted solution]

Hi @sakBI,

Thank you for reaching out to Microsoft Fabric Community Forum.

It’s unfortunate that you had to roll back after investing so much time. Hopefully, Microsoft improves the logging and transparency around errors in Gen2 soon.

In the meantime, I’d suggest capturing and documenting scenarios like this, and if possible, raising them through Microsoft Support with the Request ID. That way they can investigate backend failures, and your case might help improve stability for everyone.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @sakBI,

As we haven't heard back from you, I hope you have raised a support ticket. At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

Thank you for being part of the Microsoft Fabric Community.

Regards,

Vinay Pabbu

[tharunkumarRTK]

@sakBI 

Error message is not so useful to identify the root cause. I would suggest you to troubleshoot the issue step by step.

Instead of building all the queries at once and trying to perform the refresh,

1. Create a new dataflow gen 2

2. Add only one query and then try to perform the refresh.

3. If step 2 fails then, try to limit the data to 1000 records, please put a filter in the source query level, loading all the data into the dataflow and then filtering in dataflow (power query online) might not help.

4. If you are able to load a small set of records, then please check if the datasource has any limitations.

I guess you are able to run these queries in dataflow gen 1 with out any issue, if that is the case then reach out to the Microsoft Fabric Support team, they will be able to identify the request IDs in the error message and can help you further

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!