# \[API Logs\] - Pulling Latest Logs to Power BI
**URL:** https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657
**Category:** Logs
**Created:** [July 31, 2023, 7:28am UTC](https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657 "2023-07-31T07:28:11Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@aisyaharifin](https://discuss.elastic.co/u/aisyaharifin)
#### Post date: [July 31, 2023, 7:28am UTC](https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657/1 "2023-07-31T07:28:11Z")
Hi Elastic,
I want to ask is there a way we can continuously pulling the Elasticsearch data to Power BI Cloud for dashboard purposes?
The team currently using Azure Data Factory to pull the data from our Elastic.
Currently they pull the data using the URL and API Key to access the data.
Thank you.
---
### Author:  [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [July 31, 2023, 10:30am UTC](https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657/2 "2023-07-31T10:30:44Z")
Hi @aisyaharifin,
Not sure if this is relevant to Power BI Cloud, but are you able to use the [Elasticsearch ODBC driver similar to the desk guide in the documentation](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-client-apps-powerbi.html)?
---
### Author:  [@aisyaharifin](https://discuss.elastic.co/u/aisyaharifin)
#### Post date: [August 1, 2023, 12:42am UTC](https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657/3 "2023-08-01T00:42:35Z")
Hi @carly.richmond,
Thank you for your reply.
Apparently the documentation is not applicable for my situation.
If so how do I pull the latest data continuously from Elasticsearch?
Let's say I would like to pull the latest APM logs data continuously from Elasticsearch, how do I do that?
---
### Author:  [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [August 1, 2023, 9:46am UTC](https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657/4 "2023-08-01T09:46:01Z")
Hi @aisyaharifin ,
> [@aisyaharifin](#):
>
> Apparently the documentation is not applicable for my situation.
Can you explain a bit more about why it's not applicable? Do you not have access to the ODBC connector in Power BI Cloud?
Having a search around I can think of a few ways of getting the information into Power BI:
1. Using Azure Data Factory as you currently. I see from [this blog](https://www.cdata.com/kb/tech/elasticsearch-cloud-adf.rst) that you can create a live connection using the CData Connect Cloud Virtual SQL Server API. I'm not sure if this is what you are currently doing?
2. Using the Power BI Web connector, although looking at [this blog](https://blog.sixeyed.com/querying-elasticsearch-with-powerbi/) I worry this will require polling.
3. Using [Logstash](https://www.elastic.co/guide/en/logstash/current/getting-started-with-logstash.html) with an [Elasticsearch input plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-elasticsearch.html) and a [http output plugin](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-http.html) to call the [Power BI REST API](https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#use-power-bi-rest-apis-to-push-data) to send the data.
Do any of those work with your use case? If not do let us know a bit more about what you're trying to do.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 29, 2023, 9:46am UTC](https://discuss.elastic.co/t/api-logs-pulling-latest-logs-to-power-bi/339657/5 "2023-08-29T09:46:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.