SAP General Ledger - Extract General Ledger Accounting Data to Power BI with Python Scripts
The Power BI Connector for SAP (PCS) from DVW Analytics can be used to extract data directly from SAP into Power BI Reports and Dashboards. In this blog series I will detail all the steps needed to extract data from SAP Tables and import the associated data into Power BI via Python Scripts generated in PCS where it can be easily refreshed.
Selectively Importing Python Tables and Auto Exporting with Python
Python and Power BI There are many tutorials on Python scripts, but here I would like to offer some insights on using Python combined with Power BI. The official document already have a tutorial on how to install Python and some basic uses. We can either install python Anaconda3 pack or download python and install pandas and matplotlib packages with commands. Some commonly used packages are configured in Anaconda 3, it is not necessary to install pandas and matplotlib separately if Anaconda 3 is already installed.
