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
rubayatyasmin
Super User
Super User

Encountered operating system error 5(Access is denied.) while attempting to read physical metadata.

Hi everyone,

I'm currently working with a Lakehouse and associated warehouses in my Fabric environment. I’m able to access the Lakehouse, and while it takes some time, I can preview data for tables. However, I’m running into an issue when trying to execute queries.

I’ve tried connecting to the SQL endpoint using the connection string and managed to connect via MS SQL Server Management Studio, but I’m unable to run any queries on the tables in the Lakehouse database.

Has anyone faced a similar issue or have any insights on how to run queries in the Lakehouse using the SQL endpoint?

Thanks in advance!

 

The error in WH:

rubayatyasmin_0-1742341350996.png

 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


1 ACCEPTED SOLUTION

Thanks for the information. I checked the known issues already. My problem solved after reauthenticating all the connections. 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


View solution in original post

9 REPLIES 9
v-veshwara-msft
Community Support
Community Support

Hi @rubayatyasmin ,

Thank you for reaching out to the Microsoft Fabric Community.

Appreciate your insights, @nilendraFabric 

There have been some known issues reported related to this.


1. Table Sync Issues in West Europe Region.

Symptoms:

  • Users may experience table latency issues when syncing tables, schema, or semantic models.

Workaround:

  • Retry the sync operation as a temporary fix while Microsoft’s engineering team is working on a permanent solution.

Known issue - Sync for data warehouse and SQL analytics endpoint fail in West Europe - Microsoft Fab...

 

2. Table Sync Failures Due to Unsupported Columns

Symptoms:

  • If column mapping includes unsupported columns, the metadata sync may fail.

Workaround:

  • Check for unsupported columns in the Lakehouse table and remove them before reattempting the sync.

3. SQL Analytics Endpoint Permissions Not Persisting After Schema Changes

Symptoms:

  • Table permissions in the SQL analytics endpoint may not persist after a successful sync.

Workaround:

  • If a schema change was made, reapply permissions on the SQL analytics endpoint after sync completion.

Known issue - SQL analytics endpoint tables lose permissions - Microsoft Fabric | Microsoft Learn

 

Additionally, When using SQL Server Management Studio (SSMS), queries may fail due to local permission restrictions.

Try running SSMS as an administrator to rule out local permission issues on your machine.

 

Thank you for your patience while the Microsoft Engineering team works on resolving these issues.

Since you've already raised a support ticket, hopefully, it will be addressed and resolved soon.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Vinay.

 

Thanks for the information. I checked the known issues already. My problem solved after reauthenticating all the connections. 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Hi @rubayatyasmin , I'm having same issue. The LH and WH are on service account which may have had paswwrod change. Can you advise where did you re-authenticate. I do not see any place which asks me to sign in. 

@aflath Any help from you would also be great.

In my case, when I tried to use PBI service it asked me to log in several times. Apart from LH, WH I had data flows g2 and semantic models. I reauthincated those items as well. 

 

Best thing would be log out and log in again. Give it some time then try again. I faced this 2-3 days. After that reauthenticating items worked for me. 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


@rubayatyasmin thank you for the reposnse. 

 

It didnt ask me as many times. But 2 times. I signed in, and gave it 15 mins to sync. Then it works for me.

 

Also, I did this on office network. Error was thrown on VPN. Though Fabric is cloud-based, I will test from VPN again and possibly a port somewhere on VPN needs to be opened. I'll jump on to Fiddler, if it comes to it.

 

Thanks for the help.

Yea.  I had to reauthenticate as well.  Basically went into the Data Source setting, and re-logged in. 

Hi @rubayatyasmin ,

Thanks for the update.
Glad to hear that reauthenticating the connections resolved the issue.

Also, if this solution worked for you, please consider accepting the reply as a solution to help others facing a similar issue. If you found my response helpful as well, you may consider marking it as a solution too.

 

Thank you.

nilendraFabric
Community Champion
Community Champion

Hello @rubayatyasmin 

 

I am facing similar issue with LH tables for last few days.

 

Newly added or updated tables may not yet be visible due to stale metadata

 

Try Trigger metadata synchronization manually, although it didn't worked for me.

 

 

Seems like something has been changes behind the scenes, worth raising the support ticket 

 

 

Yeah, the tables are not new. Sync was perfect but from 2 days it started throwing errors. Raised a support ticket already at the time of posting. But as the matter needs to solve urgently thought of posting it here as well. 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


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