Hi, @Anonymous
Based on your description, you may consider using the following methods to query Tcodes in SAP.
1. Use the DVW Power BI Connector for SAP (PCS), which has a range of tools for extracting data from a variety of SAP sources, including transaction codes, ABAP reports, SAP BW queries and information providers, and SAP queries. The data can then be loaded into Power BI using the Odata source connection. When you refresh a Power BI report, the data is automatically reloaded from SAP.
Related link: Extract SAP General Ledger - G/L Account Line-Item... - Microsoft Fabric Community
2. Using the SAP Business Warehouse connector in Power BI Desktop, once connected, you can enter server, system, and client information and choose whether to use the Import or DirectQuery connection method. You can choose whether to use the "Import" or "DirectQuery" connection method.
Related link:
Solved: Connecting power bi to SAP BW - Microsoft Fabric Community
Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
