Dear all,
I am trying to build a real-live dashboard (or report in Power BI terms) to track users and usage of a platform and make strategic decisions based on this information/analysis.
Our main data source for this is a multi-dimensional data model in Elastic Search. A few questions have come up during my analysis to know if this would be possible because of my limited technical knowledge.
- Can Elastic Search be connected live to Power BI? Will we have to transform our data to fit with SSAS?
- If so, how would you tackle this transformation?
- In case we were able to use a live connection (we are willing to change our dataset to be able to do this analysis) is it possible to make multiple connections? E.g. we would have our user data and in another dataset (e.g. excel) we have information about linkedin posts, because we would like to see if we have more users because of a linkedin post or ad. Is this possible when using a live connection?
Thanks in advance!
Kind regards.
