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

Upvotes
Accepted
Cishel.Crawford avatar image
1 ●0 ●0 ●0

Eikon customer unable to synchronize Power BI via Python.

Can't synchronize with Power BI via Python.


Below is a simple example of the correct Python coding settings on my computer to synchronize with Power BI.


"import pandas as pd

data = [['Alex',10],['Bob',12],['Clarke',13]]

df = pd.DataFrame(data,columns=['Name','Age'])

print (df)"



However, when I try to synchronize the code generated via CodeBook (CODEBK) in Power BI, the loading screen for attempting to connect to Power BI doesn't work and unfortunately doesn't allow me to access the view generated for import, as shown below.



Can you help us with this? Because apparently all the previous configuration and the appropriate installations below have also been configured for access to Refinitiv.

Installations completed:
Install Python

Install Pandas
Install Matplotlib

Install Refinitiv.Data

eikon-data-apiworkspace#technologyeikon-com-apimicrosoft-power-bi
1714429612841.png (8.3 KiB)
1714429700137.png (30.3 KiB)
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.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
80.1k ●257 ●52 ●75

@Cishel.Crawford

Thank you for reaching out to us.

If you are using the desktop session which requires Eikon or Workspace running on the same machine, the code looks like this:

import refinitiv.data as rd
rd.open_session(app_key = "<app key>")
df = rd.get_data(
   universe = ["ULSD-USG"],
   fields=["TR.BIDPrice(SDate='2022-01-01', Frq='D', EDate='0')"])
print(df)

1714451550434.png

Please refer to the quick start regarding how to create an application key.


1714451550434.png (26.4 KiB)
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.