Forum Discussion

JGAlltricks's avatar
JGAlltricks
New Member
1 year ago
Solved

Cannot query data from Fabric Lakehouse SQL Analytics Endpoint using Service Principal (only schema)

Hi everyone,   I’ve been working with Microsoft Fabric and so far I’ve been able to: Write parquet files into a Lakehouse (remotely with python/azcopy), Define views with SQL remotely using O...
data warehouse
  • JGAlltricks's avatar
    JGAlltricks
    1 year ago

    Hi v-dineshya,

     

    Thank's a lot for your answer. After cheking, everything were already done.

     

    But I found a solution. I used the Onelake explorer from my desktop. I wen to the "Files" folder, and I "shared to everybody" that one.

     

    Now, I'm able to run the SQL Query with the Service Principal.

JGAlltricks's avatar
JGAlltricks
New Member
1 year ago

Hi v-dineshya,

 

Thank's a lot for your answer. After cheking, everything were already done.

 

But I found a solution. I used the Onelake explorer from my desktop. I wen to the "Files" folder, and I "shared to everybody" that one.

 

Now, I'm able to run the SQL Query with the Service Principal.

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi JGAlltricks ,

Thank you for the update. We are pleased to hear that you have found a solution. Please share the details here, as sharing the solution could help others in the community with similar issues. 

 

Regards,

Dinesh