Forum Discussion
MS FABRIC : Create a short cut with On Premises MS SQL AND GateWay
Hi
I use MS Fabric for a project.
I need to display user name in a dashbord, but i can't store the data in a table in my lake house.
Before in PBI project without Fabric it was possible to call some data with direct query.
With Fabric it's seem not possible to use direct query.
Have a question with Short cut. A short cut seem not stored but just call Data. (Data Lake and Semantic model)
I'm not found the option but is it possible to make a short cut with an on primises MS SQL and a GateWay ?
Thx
Hi ShaunLeMouton For Ms SQL server you would have to use Dataflow or ADF pipeline In this article below you could check out the details currently Shortcut is not able to do the trick
https://data-mozart.com/how-to-bring-sql-server-data-into-microsoft-fabric/
Here is the link in here it has been mentioned in detail
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
4 Replies
Hi ShaunLeMouton In the documentation it is mentioned that it is possible to connect could you check this for further clarification
https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
https://learn.microsoft.com/en-us/fabric/onelake/create-on-premises-shortcut
If this post helped please do give kudos and accept this as a solution
Thanks In AdvanceHi thk for the link.
But it's not really help me.
The article give a link " You can even create shortcuts to on-premises or network-restricted locations"
to an other article.
In the article we can read :
"With OneLake Shortcuts, you can create virtual references to bring together data from a variety sources across clouds, regions, systems, and domains – all with no data movement or duplication. By using a Fabric on-premises data gateway (OPDG), you can now also create shortcuts to on-premises data sources, such as S3 compatible storage hosted on-premises. With this feature, you can also create shortcuts to other network-restricted data sources, such as Amazon S3 or Google Cloud Storage buckets configured behind a firewall or Virtual Private Cloud (VPC)."
I see any where example with a MS SQL Server Data Base that is not in the cloud
Hi ShaunLeMouton For Ms SQL server you would have to use Dataflow or ADF pipeline In this article below you could check out the details currently Shortcut is not able to do the trick
https://data-mozart.com/how-to-bring-sql-server-data-into-microsoft-fabric/
Here is the link in here it has been mentioned in detail
If this post helped please do give a kudos and accept this as a solution
Thanks In AdvanceHi
Thx for the second link.
I have me anwser i think
- Shortcuts – I’ve already written about Shortcuts here. I honestly consider Shortcuts one of the greatest features in the entire Fabric ecosystem. However, there is (still) no option to create shortcuts to SQL Server data
It's seem not be possible to make a short cut with mssql data base in on premises
My goal is to try to do the equivalent to a direct query with a specific table.
