How to create a shortcut to reference an existing dataset or table from SQL Server in Dataflow?

[tan_thiamhuat]

I cannot find the steps to create a shortcut to reference an existing SQL Server dataset inside Dataflow. Can anyone help?

Thanks.

[suparnababu8 · Accepted solution]

Hello @tan_thiamhuat 

Firstly, May I know from where you got these steps? If you have that official documentaion link pls share here. 

Unfortunately, dataflow gen2 not supported directly to create shortcut option for SQL server connections as of now. You can create shortcut in lakehouse and from there you can pull the data in dataflow gen2.

If you want to have shortcut option in Dataflow Gen2, you can submit your idea here Fabric Ideas - Microsoft Fabric Community If you get enoguh responses, Microsoft will implemnt this in future.

Please refer this thread it ight helps you Solved: Re: Shortcut to dataflow possible? - Microsoft Fabric Community 

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[v-prasare · Accepted solution]

Hi @tan_thiamhuat,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @tan_thiamhuat,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@suparnababu8, Thanks for your prompt response.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[suparnababu8 · Accepted solution]

Hello @tan_thiamhuat 

Firstly, May I know from where you got these steps? If you have that official documentaion link pls share here. 

Unfortunately, dataflow gen2 not supported directly to create shortcut option for SQL server connections as of now. You can create shortcut in lakehouse and from there you can pull the data in dataflow gen2.

If you want to have shortcut option in Dataflow Gen2, you can submit your idea here Fabric Ideas - Microsoft Fabric Community If you get enoguh responses, Microsoft will implemnt this in future.

Please refer this thread it ight helps you Solved: Re: Shortcut to dataflow possible? - Microsoft Fabric Community 

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

[tan_thiamhuat]

I get the above information from our good and friendly 24x7 friend (ChatGPT), which I already suspect it may not be the correct information. Thanks for the confirmation. I will submit my idea to Microsoft then, it would be very useful if that is implemented. Thanks.

[suparnababu8]

😀 Thank you🤝