Forum Discussion
Hybrid Connection Manager
Does anyone know if it's possible to use a hybrid connection manager as a datasource for a powerbi report? I get the impression that it's not, given the number of internet searches I've tried.
No, Power BI does not support Hybrid Connection Manager as a data source.
Use the on-premises data gateway instead, which is the supported method for connecting Power BI to on-prem data.
Use Azure Data Factory with Hybrid Connection to move on-prem data to an Azure service (like Azure SQL DB or Data Lake).
Power BI can connect to Azure-based sources, even if the original data came from on-premises.
6 Replies
No, Power BI does not support Hybrid Connection Manager as a data source.
Use the on-premises data gateway instead, which is the supported method for connecting Power BI to on-prem data.
Use Azure Data Factory with Hybrid Connection to move on-prem data to an Azure service (like Azure SQL DB or Data Lake).
Power BI can connect to Azure-based sources, even if the original data came from on-premises.
So, we're using hcm to retrieve data from a customer on prem instance for our SPA, where previously we've been hosting the db too. The app has the ability to host embedded pbi content. Are you saying we could create a gateway that works with the hcm? If we did, how do we author the reports if we can't connect to the data source in Desktop?
Hi HumbertDugong,
Thank you for reaching out to the Microsoft fabric community forum.
Unfortunately, Power BI doesn’t support Hybrid Connection Manager as a direct data source.
To connect to your on-premises data, you’ll need the On-premises Data Gateway installed on a machine with direct access to the data source (HCM won’t work as a substitute). For authoring reports in Power BI Desktop, you’d need a machine or VPN that can connect directly to the on-premises data.
Another option is to use Azure Data Factory with HCM to move your data to an Azure service like Azure SQL Database, then connect Power BI to that Azure source no gateway needed.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find itBest Regards,
Harshitha.
Community Support Team
