Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
MG86
Advocate II
Advocate II

Can external user import data from SQL endpoint of Lakehouse?

I'm looking at a way to allow a customer to use certain data for their own analytical use in their tenant. 

 

First option I've explored that works is in-place semantic model sharing through B2B. This allows customer to direct query a semantic model made available to him. However, any report he builds and then shares with others requires that the consumers have access to our semantic model as well. This is a bit inconvenient.

 

I then wondered: a lakehouse has a SQL endpoint. Is there a way an external tenant could connect to the SQL endpoint and import the data? I assume any access is OAuth2 and he'd still need to be a guest user, but then he could just import and share as he likes? 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @MG86 ,

 

It is possible in theory, the official documentation has no relevant external user restrictions, but they have to have the appropriate permissions.What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @MG86 ,

 

It is possible in theory, the official documentation has no relevant external user restrictions, but they have to have the appropriate permissions.What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors