Forum Discussion
Troubleshooting dataflow Gen2 query
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-ticketIf 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
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
|