Forum Discussion

MG23's avatar
MG23
New Member
4 months ago
Solved

Fabric Rest API - Table Load stopped working for a service principal

I have a lakehouse that we load data into via a C# program which uses the load table rest api to load data from an uploaded parquet file into a table.  It was working well until some point in the pas...
Lakehouse
  • MG23's avatar
    MG23
    4 months ago

    Just as a follow up for anyone else who runs into this issue, after working with Fabric support we determined this is an known issue where the an internal refresh token associated with the SP expires inside of fabric.  Calls to the load API do not refresh the token.  To refresh the token you have to call control plane APIs (for example, list workspace API) which cause the internal token to refresh.

     

    I'm updating our process to call a control plane API prior to the current load operation to ensure the token always stays fresh.

MG23's avatar
MG23
New Member
4 months ago

Just as a follow up for anyone else who runs into this issue, after working with Fabric support we determined this is an known issue where the an internal refresh token associated with the SP expires inside of fabric.  Calls to the load API do not refresh the token.  To refresh the token you have to call control plane APIs (for example, list workspace API) which cause the internal token to refresh.

 

I'm updating our process to call a control plane API prior to the current load operation to ensure the token always stays fresh.