Forum Discussion

choran's avatar
choran
Regular Visitor
2 years ago

How to get lakehouse files into Azure Function

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?

data science
environment

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      choran
      Regular Visitor
      2 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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