Live Feed to PowerBI
We make extensive use of PowerBI and query the SMA. Here's an old blog post of mine that covers setting up PowerBI Desktop:
Since I wrote that I have developed some better methods, but that will get you started. One thing that isn't covered in that post is updating a report after it is published to the PowerBI service. That is possible as long as you have a data gateway available that can get to the SMA.