Power BI and API

Hi there,
After I got into automapping, the next step towards a more efficient LCA calculation process for me, is a faster and better way to present the result, without using hours in excel. Therefore I have tried to make API, Postman and PowerBI do the work for me. But I don’t get that far before I got into trouble… :shushing_face:

I got this error after I typed my mail and password into the code in postman:
Error: getaddrinfo ENOTFOUND {{fronteggauthurl}}

Can you help me? Or are there anyone else who have experienced the same issue?

Best regards,
The API and PowerBI Rookie

2 Likes

Hi @JakobKlinkwort :wave:

Welcome to your new Real-Time LCA Community - so happy to see you here! :tada:
Please feel free to introduce yourself to the Community here:

Really cool that you want to leverage the data in other applications!
To answer your question, the error might occur since you need to choose the production environment in the top left corner of the Postman app, before you execute the Authenticate user POST request.
It looks something like this:

image

This sets the urls to the production environment for the different requests in the Postman Collection.

Hope it works out for you!

/Martin

I had and resolved a similar issue, but almost immediately run into another one. When I open the RTLCA PBI Dashboard Template, I am asked for my username and password, which I enter, but I am never asked for the Token, as I am told I will be by the training video. Instead I am asked for a few different ways to Access Web Content. I have tried locating the Token data and my username/password in various options, but have been unable to get to the data… help?

Hi @AndreaHBIG :wave:

Nice to see you in here!
The instructional video for the PBI template hasn’t been updated accordingly to the new authentication method. We’re no longer use the token but the username and password.
I will make sure to update the video asap.

For the step in the screenshot, you simply use Anonymous and click Connect - the dashboard should start loading.

/Martin

Hi again @AndreaHBIG

I just updated the video guide.

Since you already tried to load the data, You might need to reset the permissions by going to File > Options and settings > Data source settings.
Here select Clear All Permissions.

2 Likes

Hi team

I have noticed a few errors with the current powerBI template.

Top 10
The Highest Emission Impact by Type is available, but at the moment the Highest Emission Impact by Material isn’t.

Models
There seems to be an error with the Emission by Model. In the example, it says that the Arkitektur model accounted for 100% of the emissions, but according to the Insights view in the browser it should be 91,8% and 8,2% for Mekaniske installationer.


Hi @MarkLabrosse

I will make sure to update the PowerBI Template file with a correct and corresponding tables.

Br
Martin

1 Like

Hi @martinromby

Have you updated the PowerBI template? We cannot seem to get it working at the moment.

Br.
Jonas