Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm having issues with refreshing a dataflow gen2. It gives the Error code: 101238, of which I can't find any documentation. It seems to suggest that the datatypes are not correct. However, I've tried refreshing it with a simple table containing all text columns and I still get the same error message.
Is it possible the source (AFAS) has something to do with it? I can query the data in the dataflow just fine. It's really the writing to the lakehouse (I've also tried Warehouse as a destination) that doesn't work.
I've created another dataflow with SQL as a source and that has not had any issues.
Hi @JK_CM ,
Just checking in were you able to raise a support ticket with Microsoft regarding the Gen2 write issue? If so, would be great to hear if they shared any updates or workaround.
Regards,
Akhil.
Unfortunately not, since I don't have the (admin) rights to do in this environment
Hi @JK_CM
Totally get that, when something so simple won’t go through. And yes, it’s odd that even a tiny table with all text fields fails. Good to hear notebooks are working as a workaround but agreed, it’s not as convenient as dataflows for quick transformations. This might be a backend bug with the Gen2 writer. Might be worth logging a support ticket with Microsoft, especially since Gen1 works fine and it’s clearly not a data issue. I’d recommend raising a support ticket with Microsoft so it’s officially logged and can help influence future improvements. You can do that here. https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Regards,
Akhil.
Hi @JK_CM
Thanks for confirming it's a REST API. Since Gen1 works fine, the issue is likely with how Gen2 handles writing to the Lakehouse or Warehouse.
A few quick things to check.
Gen2 can be a bit sensitive with schema mapping, especially during write operations.
Let us know if any of these help.
____________________________________________________________________________________________________________________________
If the response helped resolve your issue, please consider marking it as Accepted as Solution and give it a thumbs up if you found it helpful.
Best regards,
Akhil.
I've tried this with a single table containing 9 rows and three text columns and am still getting the same error. I've switched to a notebook, which seems to work. It's very unfortunate, because I really like working with dataflows.
No, I'm using a REST API. When I use a dataflow Gen1, I'm not having any issues.
Hi @JK_CM
by any chance the data source in your case is on prem and u are using data gateway
Error 101238 in Dataflow Gen2 typically occurs when writing data to a Lakehouse or Warehouse destination, often linked to connectivity issues, gateway configurations,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
29 | |
15 | |
6 | |
6 | |
3 |
User | Count |
---|---|
48 | |
43 | |
15 | |
7 | |
6 |