Connecting SAP DWC via ODBC to power BI

[Anandhu12]

We were trying to establish a connection from SAP  DWC to Power BI using ODBC.We were able to import model from DWC to Power BI desktop .After publishing the dashboard created using the imported model, is it possible to maintain a connection from Power BI service to DWC through ODBC by creating a gateway connection? The objective is to maintain a sheduled refresh to fetch data from DWC. Is it feasible to use ODBC in that manner?

[Shahfaisal]

The answer to your question is yes, you can use the ODBC connection via a gateway in Power BI Service. You just need to add your ODBC data source to the gateway in Power BI and then map the data source in your report to the data source in the gateway. For details, go through this article - Refreshing ODBC data source in Power BI Service