Forum Discussion

Reem's avatar
Reem
New Member
8 years ago

Live connection between Power BI and Elastic Search

We are working on an Enterprise News Management System that allows users to create, edit, circulate and publish news stories. We would like to enhance the system by adding a statistical module that allows managers at customer side to create visual reports and dashboards summerizing the overall performance at their organization. Sample reports are: average news coverage time, editors/translators performance reports.  

 

It is required that all reports support fuzzy text search in news title and content (story text) and that results are returned in timely manner. Currently, our system provides quick text search in news repository through elastic search. So, my question is can I create reports using Power BI that maintains a live connection with elastic search and gets the charts data directly from elastic through Rest API calls instead of having to import data to Power BI SQL Server DB ? 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Reem,

    It is not possible to use live connection mode in Power BI Desktop to connect to Elastic Search. You can review the data sources supported by DirectQuery in this article.

    In addition, you can consider to import data to SQL database, then use DirectQuery mode.

    Regards,
    Lydia

  • ross_lambert's avatar
    ross_lambert
    Regular Visitor
    8 years ago

    Hi Reem,

     

    Blueprint Technologies (my employer) has a product, Conduit, that can not only connect Power BI to Elastic Search but also do so with DirectQuery. I think it will do most of what you need, and we can probably chat about the rest.

     

    Ping me if you still need this.

     

    Thanks,

     

    == Ross ==