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.
Self-Query Tool
Not sure if this is the right place to ask this so forgive me if its not. I'm looking to find a tool that is easy for business analysts to use for self-querying and extracting/exporting data from Power BI datasets. DAX Studio is great and, for the most part, very easy to use. However, when it comes to logical OR conditions and nested filtering (nested ORs, ANDs) there doesn't seem to be any easy way to do this. Instead it requires manual manipulation of the DAX code. Analyze in Excel is also great but it too (and Pivot Tables in general) doesn't seem to have a way to do complex filtering nor long list filtering. It would be great if the business analysts would just learn DAX but, in my organization at least, there is not a willingness to expect that from the analysts nor the will/resources to train them. Same goes for SQL. Plus, mastery of DAX can be a very long, difficult road. Looking for a drag and drop type experience. Thanks in advance for any suggestions as to tools I can take a look at.
Is there a way to auto extract a template PBIT from a PBIX file or get a PBIT from the PBIRS API?
We are trying to use the Power BI on-prem API to Get all the reports and download them to a folder (we were able to POC this). Then we would like to extract the template file -or- remove all data from the files so we could check them into source control. Because these reports can be very large and contain very sensitive data, we need the data scrubbed from the files. Is there a way to do this?
