The equivalent of SHIR in fabric ecosystem is on Premises data gateway.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

Process: https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

Install the gateway on a server and set up a connection in fabric using the gateway.

then use that connection as a source in fabric data pipeline copy activity