Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvote
Accepted
Karl Young avatar image
16 ●1 ●1 ●6

Connecting via Power BI?

Question: what is the best way to connect to Thomson Reuters data using Power BI?

I am a Business Intelligence consultant, and my client is a subscriber of Thomson Reuters. Currently he gets his data from Thomson Reuters (financial statements of specific companies) in Excel files, which are bloated with macros and useless cells. They are too heavy to process them efficiently, so I clean them manually. Then I combine all those files and create a dashboard using Power BI. Needless to say, this is less than ideal.

Ideally I would like to get JSON, XML, CSV or something similar via API -- all selected companies at once -- is it possible?

P. S. Not sure if this is the right space though.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apimicrosoft-power-bi
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Christiaan Meihsl avatar image Christiaan Meihsl

@temporarymailyo

What Thomson Reuters product is your customer using to get this data ?

Karl Young avatar image Karl Young Christiaan Meihsl

Christiaan, my customer is using Global Fundamentals and the platform is EIKON.

Christiaan Meihsl avatar image Christiaan Meihsl Karl Young

I guess your client must be using Eikon for Excel, and taking templates from the library, which are designed for human ease of use, not for integration.

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01
@iain.scott

Could you help the client on this?

Sarit Chantasuban avatar image   Sarit Chantasuban

@Karl Young

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks, AHS

chavalit-jintamalit avatar image   chavalit-jintamalit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS

wayne.winter avatar image wayne.winter

Did you manage to come right?

I am trying to do the same thing.

Karl Young avatar image Karl Young wayne.winter

My client mentioned that the service suggested by Christiaan costs almost twice as much, so we ended up writing a VBA script that pre-processed the Excel files from Thomson Reuters for Power BI consumption.

2 Answers

· Write an Answer
Upvotes
Accepted
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

For fundamental data you might also want to look at a separate product, TRKD (Thomson Reuters Knowledge Direct), which has a web services SOAP API that delivers XML data.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Jirapongse avatar image
79.2k ●251 ●52 ●74

To get JSON, you can use Eikon Scripting API. However, Eikon Scripting API requires Eikon Scripting Proxy. You need to run Eikon Scripting Proxy on the same machine in order to retrieve the data. Moreover, Eikon Scripting Proxy requires Eikon credential. Therefore, this could be the problem because Eikon and Eikon Scripting Proxy with the same login may not be able to run simultaneously. In addition, this product is still in EAP (Early Access Program) phase with the main aim of validating the APIs.

Other Eikon APIs return an object so that application needs to access object's properties or methods in order to retrieve the data. However, the application can programmatically convert the object to JSON, XML, or CSV format. For more information, please refer to COM APIs for use in custom applications or .NET APIs for use in custom applications in this page.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.