Chatbot integrating with Business Intelligence tool

My ideia is do a chatbot that makes integration with business intelligence tool
I will explain a little bit...
I want integrate a low cost tool that is pentaho (open-source) for etl.
After that I want to use some tool of BI for dashboarding, like PowerBI, Microstrategy connecting with Pentaho

Inside of Microstrategy by example,  I can make available these dashboards in a html frame. And this is very important for what I want to do!

Because I need embed this content in a chatbot talking.


Finally, i have a chatbot already developed. And is integrating with Google Dialogflow, and when a client writes an example: "I want the annual sales of client INTELLIPAAT of  2015"
I can extract these words in json by example:

{
"required-client":"intellipaat Inc",
"required-year": "2015",
"report-type":"sales",
"frequency": "annually"

}
After that, today I think that the best way to have a dinamic data consulting is passing these keys in a url for a Microstrategy like this:
http://microstrategy-dashboard-center-url/report?=${report-type}&frequency?=${frequency}&year?=${required-year}&client?=${required-client}

And the dashboard render in response of chatbot conversation.

Most important things
1st: Make connection of BI tool (power bi/microstrategy) with Pentaho for real dinamic data
2nd: Do available dashboards with an URL with this BI Tool
3rd: pass the word-keys of chatbot to URL of dashboard


Tks