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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
DanielAmbler
Helper II
Helper II

Couldnt load table error - but can preview data fine

Hi,

 

After writing a dataframe to the Lakehouse as a table

 

MyTable.write.format("delta").mode("overwrite").saveAsTable("MyTable")  (N.B - also tried using save( full ABFSS path)
 
 - The table is created fine, displays in the notebook source explorer and lakehouse explorer
 - I can preview the data in lakehouse explorer
 
however
 
 - When trying to expand the table columns in Lakehouse Explorer - the table displays a red cross with an error 'Couldnt load table' - the message is 'Server Error' ' The requested Lakehouse operation failed'  (details below)
 - Cannot see the table via the SQL endpoint.
 
Where do I begin troubleshooting?
 
Server Error.
Message : The requested Lakehouse operation failed. A retry of the operation may help.
Error Code : LakehouseOperationFailed
Activity Id (Failed Request) : a2d819e4-3c43-4ce3-8556-79ad718ce623
Client Session Id : ad30364c-9c09-4754-9048-64f5ee65025c
Activity ID (Initial Request) : 40fb6e11-fdf6-45cc-a794-f5ff89d99362
User session Id : e2c056cd-1317-41a5-9f33-c1ea87dfffc9
 
 
1 ACCEPTED SOLUTION
v-cboorla-msft
Microsoft Employee
Microsoft Employee

Hi @DanielAmbler 

 

Thanks for using Microsoft Fabric Community.

While you mentioned using "delta" format for writing, ensure the data format in the table is compatible with Lakehouse Explorer's preview functionality. When you write your DataFrame to the Lakehouse as a Delta table, there might be a mismatch between the data types in your DataFrame and the data types expected by Lakehouse Explorer for displaying the table schema.

If a column in your DataFrame contains data of a type not natively supported by Lakehouse Explorer for previewing, it could cause issues when expanding the table columns. For example, complex data types like nested structures might not be easily displayed. Before writing to Delta format, inspect the data types of each column in your DataFrame.

For more details please refer : Data types - Microsoft Fabric | Microsoft Learn

For a similar issue please refer : Solved: The requested Lakehouse operation failed. A retry ... - Microsoft Fabric Community

 

I hope this information helps.

 

Thank you.

View solution in original post

3 REPLIES 3
DanielAmbler
Helper II
Helper II

Hi @v-cboorla-msft - Thanks for the reply.  I had a complex explicit schema defined with quite a few columns that had to be aliased in the final dataframe.

 

It was an aliased column that had a name of "" (i.e blank) that was causing the issue.

 

It wasnt a data type in the end but your response did prompt me to have a good look at the dataframe with some fresh eyes and gave me some ideas for building some basic sanity checks for the future.

Hi @DanielAmbler 

 

Glad that your query got resolved.
Please continue using Fabric Community for further queries.

 

Thank you.

v-cboorla-msft
Microsoft Employee
Microsoft Employee

Hi @DanielAmbler 

 

Thanks for using Microsoft Fabric Community.

While you mentioned using "delta" format for writing, ensure the data format in the table is compatible with Lakehouse Explorer's preview functionality. When you write your DataFrame to the Lakehouse as a Delta table, there might be a mismatch between the data types in your DataFrame and the data types expected by Lakehouse Explorer for displaying the table schema.

If a column in your DataFrame contains data of a type not natively supported by Lakehouse Explorer for previewing, it could cause issues when expanding the table columns. For example, complex data types like nested structures might not be easily displayed. Before writing to Delta format, inspect the data types of each column in your DataFrame.

For more details please refer : Data types - Microsoft Fabric | Microsoft Learn

For a similar issue please refer : Solved: The requested Lakehouse operation failed. A retry ... - Microsoft Fabric Community

 

I hope this information helps.

 

Thank you.

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082