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.
Best Answer
-
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.
0
Answers
-
Christiaan, my customer is using Global Fundamentals and the platform is EIKON.
0 -
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.
0 -
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.
0 -
Did you manage to come right?
I am trying to do the same thing.
0 -
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.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 554 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 642 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 89 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛
