Forum Discussion

ericjo's avatar
ericjo
Icon for Helper III rankHelper III
8 months ago
Solved

Power BI Connect to SAP t-code

I'm looking for a way to connect SAP t-code data to Power BI. I found a paid connector called DVW Connector, but it's not available due to regulatory restrictions. 1. Directly connecting Power BI a...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rohit1991's avatar
    rohit1991
    8 months ago

    Hii ericjo 

     

    Power BI cannot connect directly to an SAP t-code because a t-code is only a front-end transaction, not a data source. Power BI can connect only to SAP backend data such as SAP tables, CDS views, BW queries, or HANA views.If direct access is not allowed, a workaround is using Power Automate Desktop to run the t-code, export data to Excel, save it to SharePoint/OneDrive, and then connect Power BI to that file but this is not recommended for enterprise use.

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
8 months ago

Hi ericjo    

 

I’m not familiar with the SAP system, but to offer a suggestion, how about extracting the data using another method, such as Python (for example: https://www.youtube.com/watch?v=3DpUHmrxpZ4),  

and then pushing the data to a data source that Power BI can access?