Forum Discussion
Why Creating semantic model based on DataLake on OneLake Layer still shows SQL endpoint?
Hello,
I am watching this tutorial abut building remote semantic models on DataLake on OneLake layer:
https://www.youtube.com/watch?v=Z0tgA_pYK1s
Why in the linear view I see still SQL endpoint?
And the same after downloading report created on this remote semantic model into power bi, there is still SQL endpoint? And direct query while refreshing visuals?
Can anybody explain it?
Best,
Jacek
Hi jaryszek ,
When you create a report in Power BI desktop and publish you will find a semantic model and a report that is the expected behaviour.
SQL analytic endpoint is automatically configured whenever we create a Lakehouse, Cosmos DB or SQL DB.
If your requirement is to have SQL analytic endpoint for your data, I suggest you get the required data into lakehouse.
Thank you.
4 Replies
Hi jaryszek ,
Thanks for reaching out to the Microsoft fabric community forum.This is expected behavior. Even when you create a semantic model on top of a Lakehouse in OneLake, the lineage view will still show the SQL analytics endpoint. That’s because every Lakehouse automatically provides this endpoint as the relational interface for Power BI.
In Direct Lake mode, queries are served directly from the parquet files in OneLake (not through the SQL engine), but the SQL endpoint is still shown in lineage as the connection object.
Please go through the below documents which may help you to resolve the issue:
https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support TeamOk but the difference is that when I am creating new semantic model on OnaLake through power bi dekstop,
additional sql layer is not created...
Why fabric and desktop are different while creating a new semantic model on OneLake?
Best,
JacekHi jaryszek ,
When you create a report in Power BI desktop and publish you will find a semantic model and a report that is the expected behaviour.
SQL analytic endpoint is automatically configured whenever we create a Lakehouse, Cosmos DB or SQL DB.
If your requirement is to have SQL analytic endpoint for your data, I suggest you get the required data into lakehouse.
Thank you.
