topic Re: Cannot list Files or Tables in a Lakehouse in Data Engineering

Cannot list Files or Tables in a Lakehouse

flowerkowski — Mon, 29 May 2023 08:59:13 GMT

Hi All,

I have activated Fabric on my tenant and I am the Power BI admin of the tenant, I have also activated Fabric trial, but whenever I create a workspace in a Trial capacity and try to create a Lakehouse I get these errors shown in the images below:

I have opened a support ticket to MS, but has anyone faced with a simillar issue or knows what I need to to to fix this?

The SQL Endpoint is working fine in the meantime I can connect to it.

Thanks in advance, please let me know if you need additional info.

Kind regards,

Dejan

Re: Cannot list Files or Tables in a Lakehouse

GeethaT-MSFT — Mon, 29 May 2023 20:24:08 GMT

No, I don't see this error, So you just created a Lakehouse in fabric and you see this error?

Re: Cannot list Files or Tables in a Lakehouse

flowerkowski — Tue, 30 May 2023 06:35:13 GMT

Yes, additionaly I tried to install the OneLake desktop client and it is not working, the errors in the diagnostic log files are something like this:

status: Forbidden [403]. GET https://api.onelake.fabric.microsoft.com/?comp=list

ERROR|Initialization of core failed: Microsoft.OneLake.FileExplorer.Common.Exceptions.LakeStorageErrorException: OneLake is not supported for the current tenant f91cd4eb-xxxxxx-xxxxxxx-xxxxx-xxxx. (Forbidden)

I have Fabric enabled at that same tenant:

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Tue, 30 May 2023 16:49:51 GMT

I had the same issue,my table and files folder are also not loading

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Tue, 30 May 2023 17:08:50 GMT

Is it due to trial version or not having mircrosoft BI Pro

Re: Cannot list Files or Tables in a Lakehouse

GeethaT-MSFT — Tue, 30 May 2023 17:27:25 GMT

Can you please share the steps you have followed?

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Tue, 30 May 2023 17:57:58 GMT

First I click the Lakehouse

and I name it lakehouse_test, then following screen appear

As you can see red sign before the Folders, there are not loading. On clicking them, I get

Only the SQL endpoint is loading.
Additionally uploading file does not work as well

Re: Cannot list Files or Tables in a Lakehouse

GeethaT-MSFT — Tue, 30 May 2023 19:18:10 GMT

Can you re-login and see if the error still exists, I think some issue related to access as Endpoint is created.

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Tue, 30 May 2023 19:28:00 GMT

No still there is problem.
Even Creating the subfolder give error

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Tue, 30 May 2023 19:30:39 GMT

Refreshing the folder gives

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Tue, 30 May 2023 20:06:17 GMT

The files are accessible using notebook. I created three directories using python and are listed using python

Re: Cannot list Files or Tables in a Lakehouse

GeethaT-MSFT — Tue, 30 May 2023 20:12:56 GMT

Thanks,

Good to know, so the issue is only with Lakehouse

Re: Cannot list Files or Tables in a Lakehouse

flowerkowski — Wed, 31 May 2023 07:11:23 GMT

@GeethaT-MSFT , @wahmed20 I think I made progress with this issue, and I think the issue is with my machine not beeing in the same domain as the Fabric account (working as a contractor for a company).
@wahmed20 Have you tried instaling the OneLake File Explorer, I think this caused the issue on my side. Yesterday I spinned up Win 10 Virtual Machine in the subscription of the customer I am working for and from that VM I do not see the issue:

So now the question is is there a way to work on the OneLake and the Lakehouse from a machine that is not in the same domain as the MS Fabric account?

Thanks.

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Wed, 31 May 2023 07:34:08 GMT

Thank you, but one lakes crashes after entering login information

Re: Cannot list Files or Tables in a Lakehouse

flowerkowski — Wed, 31 May 2023 07:36:46 GMT

Same for me, but I am logged in on my laptop with anoter email/domain and I try to log in to OneLake with a different one, maybe this is the issue.

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Wed, 31 May 2023 07:50:08 GMT

I am logged in with company laptop and entering company credentials into onelake it does not listed in FileExplorer

Re: Cannot list Files or Tables in a Lakehouse

GeethaT-MSFT — Wed, 31 May 2023 12:55:52 GMT

@flowerkowski Good to know that your issue is not resolved and Thanks for sharing the information here with the community

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Thu, 01 Jun 2023 05:54:21 GMT

It is now working, the successful installation of OneLake make it to work.

Re: Cannot list Files or Tables in a Lakehouse

flowerkowski — Thu, 01 Jun 2023 05:57:53 GMT

How did you manage to reinstall it after the login crashes? Thanks a lot.

Re: Cannot list Files or Tables in a Lakehouse

wahmed20 — Thu, 01 Jun 2023 06:00:21 GMT

I check my all setting from admin and logout from fabric. Restarted Machine and install onelake