Which is the best way to connect the Power BI into the Eikon API?

Question

question

edu

1 ●0 ●0 ●1

Which is the best way to connect the Power BI into the Eikon API?

Hello,

I'm trying to connect the Reikon API as a database into Power BI to generate some portfolio for our company and I'm following the two guides below but no success until now unfortunately.

1 - "Eikon Data API on Power BI app with py script" post

https://community.developers.refinitiv.com/questions/80765/eikon-data-api-on-power-bi-app-with-py-script.html

About that post, I would like to ask where I can find my "ek.set_app_key" to input into a similar code that the user Jirapongse mentioned.

2 - "How to integrate DSS/RTH data into Power BI Desktop" article

https://developers.lseg.com/en/article-catalog/article/how-integrate-dsstrth-data-power-bi-desktop

I advanced more into that guide and I did everything like the article says, even creating an HelloWorld example for testing (which worked). I followed the same steps for the DSS/RTH but the CustomerConnector doesn't appear into the Power BI as a valid data source. I'm assuming that the only change in the code that I need to do (if I really need to change something) is that "user" / "pass" part to my personal login info, right?

Additionally, in the "DSSDemoExtension.query.pq" file below appears the message "The name 'DSSDemoExtension.RTHTimeSeries' doesn't exist in the current context" and I don't know if the code should really behave like that in the Visual Studio.

Thank you in advance for all help that I can get.

#technology dss-rest-api python api microsoft-power-bi

1706533650536.png (20.7 KiB)

1706533696496.png (5.3 KiB)

Jan 29 at 01:06 PM

10 |1500

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

Answer 1 · 2024-01-29T14:18:33Z

jason.ramchandani01

10.3k ●18 ●6 ●9

@edu Thanks for your questions - so regarding the first point, you can find the Eikon App key in the APPKEY app in the Eikon Desktop (type APPKEY into the Eikon search bar). You can then create a new app key (if you don't already have one - check the Eikon Data API option) - see picture below:

Regarding your second point on DSS - did you install the Power Query SDK from VS marketplace? That is a precursor step I believe.

I hope this can help?

1706537429500.png (28.8 KiB)

Jan 29 at 02:18 PM

10 |1500

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

edu Jan 29 at 03:51 PM

Thank you @jason.ramchandani01, that info about the appkey was very helpful!

I did everything properlly from a basic Microsoft tutorial teaching how to create Custom Connectors in Visual Studio to link a power query SDK file into the Power BI. I made a simple HelloWorld and everything worked fine on Power BI, but unfortunately the DSS/RTH example didn't worked in Power BI after creating the DSS Custom Connector and I don't know what am I missing.

Bellow I'm sending my screen to showcase my DSSDemo project from Visual Studio.

captura-de-tela-2024-01-29-124139.png (117.3 KiB)

Answer 2 · 2024-02-14T10:19:13Z

Jirapongse

79.7k ●257 ●52 ●74

@edu

I got the same error in Visual Studio.

However, I can build the project properly.

The DSSDemoExtension.mez file is created properly.

It also appears in the Power BI Desktop after adding it in the [Documents]\Microsoft Power BI Desktop\Custom Connectors folder, as mentioned in this article.

Then, I can get the data properly.

1707905756896.png (10.5 KiB)

1707905892755.png (47.8 KiB)

Feb 14 at 10:19 AM

10 |1500

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

Jirapongse Feb 14 at 10:19 AM

The output is:

1707905966085.png (66.5 KiB)

Q&A Forum

question

Which is the best way to connect the Power BI into the Eikon API?

2 Answers

Write an Answer

question

Which is the best way to connect the Power BI into the Eikon API?

2 Answers

Write an Answer

Related Questions