RE: Integration with PowerBI
Hello,
The project for the Power BI Templates can be found on GitHub. it contains one version that features the code that takes all the 'heavy lifting' to access the Profile data and Interaction data, the latter form the Azure Blob storage you have configured within the marketing apps admin area.
The code provides really convenient tools to discover all data available for Your instance and allows to with a few instructions to access any data you are interested in for you own queries and visual representations.
It also features parameters to specify you org and data source and recency timeframe for interaction data filtering. (You want to select meaningful time range based on the interactions you report on and the data generated by you org. Start conservative with small recency in order to achieve good performance, opposed to load all data history for all interaction s and all profiles!)
The project on GitHub has ready to download Power BI templates files, but you can also access the PBX files in code.
And there is not only a generic template but a specific analytics report for Email Marketing which you can study. It shows how to implement a PBI report with the code provided.
There will me more reports like this available in the future. If you like to list out you specific use cases please feel free to share. We may be able to give more specific hints for your requirements.