Yes, we can easily connect to the local network data sources. Use the on premises Data gateway for that.
The On-premises Data Gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn’t in the cloud) and several Microsoft cloud services like Power BI, Power Apps, Power Automate, Azure Analysis Services, and Azure Logic Apps.
You can download on permises data gateway from this location.
Once downloaded, Run the downloaded executable to install and configure the on-premises data gateway.
