How to get lakehouse files into Azure Function

[choran]

Hi all,

I am currently creating an Azure Function and I need to retrieve contents from a Lakehouse. I have been to get the lakehouse details successfully with my code while utilising the call outlined at: Items - Get Lakehouse - REST API (Lakehouse) | Microsoft Learn

However, I am unable to actually retrieve the actual files in my code. This is the error that I get Error: 401
{"error":{"code":"Unauthorized","message":"Authentication Failed with Audience validation failed for audience 'https://api.fabric.microsoft.com'"}}.

The user is an owner of the azure resource group in which the capacity is created.

The access token is generated successfully and allows me to access details of lakehouse and the workspace.

Can someone advise me on the correct get request and how to pass this authentication issue?

[Anonymous]

Hi @choran,

Have you assign the correspond permission to allow azure function invoke rest api and turn on the  allow use rest api options?

Admin API admin settings - Microsoft Fabric | Microsoft Learn

BTW, what type of license are you worked on? Fabric capacity or fabric trial? AFAIK, the trial version is different from fabric capacity, you may not directly interact resources across different environments(trial and payment).

Regards,

Xiaoxin Sheng

[choran]

Hi Xiaoxin!
Issue still persists after changing admin api settings. I am working with Fabric capacity.

[Anonymous]

HI @choran,

Did you means to direct use azure function to access to the fact files from the paths? Can you please share some more detail about these operations? 

Regards,

Xiaoxin Sheng