We periodically get variations of the above request.
Currently, the best approach is to use SMART Connect APIs - either to pull the data directly into the BI solution (e.g. by developing a custom connector) or to pull the data into an SQL or other database that can then be more easily directly from the BI solution.
Both of these approaches require engineering/programming resources and so we appreciate most sites don’t have the resources to implement this.
If a group of SMART users was interested in integrating with a specific BI tool, we’d be happy to dive deeper and explore what it would take to develop a shared solution.
Please share thoughts/needs here.