# Power BI and API **URL:** \ **Category:** Help\ **Tags:** rest-api, powerbi\ **Created:** [February 15, 2024, 1:33pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52 "2024-02-15T13:33:06Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![JakobKlinkwort](https://dub1.discourse-cdn.com/flex005/user_avatar/community.realtimelca.com/jakobklinkwort/32/73_2.png) [@JakobKlinkwort](https://community.realtimelca.com/u/JakobKlinkwort)\ **Post date:** [February 15, 2024, 1:33pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52/1 "2024-02-15T13:33:06Z")
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… 🤫 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 ---
**Author:** ![martinromby](https://dub1.discourse-cdn.com/flex005/user_avatar/community.realtimelca.com/martinromby/32/22_2.png) [@martinromby](https://community.realtimelca.com/u/martinromby)\ **Post date:** [February 15, 2024, 1:59pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52/2 "2024-02-15T13:59:40Z")
Hi @JakobKlinkwort 👋 Welcome to your new Real-Time LCA Community - so happy to see you here! 🎉 Please feel free to introduce yourself to the Community here: > [@Introduce yourself person\_raising\_hand](https://community.realtimelca.com/t/introduce-yourself/32): > > Welcome to the Real-Time LCA Community! wave Congratulations on reaching this point, and we’re thrilled to have you here. We’d love to get to know you better, so why not take a moment to introduce yourself? Share a glimpse of your interests and what keeps you engaged. Additionally, consider adding a profile picture – it’s a great way to enhance your online presence and connect with our community. – I’ll kick things off with a quick intro! I’m Martin, and I wear a few different hats over … 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](https://europe1.discourse-cdn.com/flex005/uploads/realtimelca/original/1X/169556fb969cdd8a7bd0559ca28cc1f8a8cac71d.png) This sets the urls to the production environment for the different requests in the Postman Collection. Hope it works out for you! /Martin ---
**Author:** ![AndreaHBIG](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@AndreaHBIG](https://community.realtimelca.com/u/AndreaHBIG)\ **Post date:** [October 24, 2024, 1:49pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52/3 "2024-10-24T13:49:04Z")
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? ![image](https://europe1.discourse-cdn.com/flex005/uploads/realtimelca/original/1X/bbc95cca13c3416f57c33b2fe286146c2375ca4f.png) ---
**Author:** ![martinromby](https://dub1.discourse-cdn.com/flex005/user_avatar/community.realtimelca.com/martinromby/32/22_2.png) [@martinromby](https://community.realtimelca.com/u/martinromby)\ **Post date:** [October 24, 2024, 2:30pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52/4 "2024-10-24T14:30:53Z")
Hi @AndreaHBIG 👋 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 ---
**Author:** ![martinromby](https://dub1.discourse-cdn.com/flex005/user_avatar/community.realtimelca.com/martinromby/32/22_2.png) [@martinromby](https://community.realtimelca.com/u/martinromby)\ **Post date:** [October 29, 2024, 1:14pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52/5 "2024-10-29T13:14:46Z")
Hi again @AndreaHBIG I just updated the video guide. > **[Video guides | Real-Time LCA](https://realtimelca.com/en-us/instructions/#powerbi)** > > With Real-Time LCA you get automated, continuous insight into the project's CO2eq, from your 3D models and calculated with data from one of the most comprehensive, valid and user-friendly environmental database for building materials. 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. ![image](https://europe1.discourse-cdn.com/flex005/uploads/realtimelca/original/1X/af9eeff002473b3796a4e4f3fc71ebdcf78ca151.png) ---
**Author:** ![MarkLabrosse](https://dub1.discourse-cdn.com/flex005/user_avatar/community.realtimelca.com/marklabrosse/32/206_2.png) [@MarkLabrosse](https://community.realtimelca.com/u/MarkLabrosse)\ **Post date:** [March 14, 2025, 1:41pm UTC](https://community.realtimelca.com/t/power-bi-and-api/52/6 "2025-03-14T13:41:29Z")
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. ![image](https://europe1.discourse-cdn.com/flex005/uploads/realtimelca/original/1X/c4ec73d6c0bd776c31a539b08b4885387e5577dd.png) **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`. ![image](https://europe1.discourse-cdn.com/flex005/uploads/realtimelca/original/1X/99aadb4f42f770c2eadc296f8d999a6a9b451592.png) ![image](https://europe1.discourse-cdn.com/flex005/uploads/realtimelca/original/1X/6de27b4dcb056caffa9094f2785d5f4cd0c878bd.png) ---
**Author:** ![martinromby](https://dub1.discourse-cdn.com/flex005/user_avatar/community.realtimelca.com/martinromby/32/22_2.png) [@martinromby](https://community.realtimelca.com/u/martinromby)\ **Post date:** [March 18, 2025, 7:10am UTC](https://community.realtimelca.com/t/power-bi-and-api/52/7 "2025-03-18T07:10:11Z")
Hi @MarkLabrosse I will make sure to update the PowerBI Template file with a correct and corresponding tables. Br Martin ---
**Author:** ![Jok](https://avatars.discourse-cdn.com/v4/letter/j/ba9def/32.png) [@Jok](https://community.realtimelca.com/u/Jok)\ **Post date:** [April 15, 2025, 8:03am UTC](https://community.realtimelca.com/t/power-bi-and-api/52/8 "2025-04-15T08:03:48Z")
Hi @martinromby Have you updated the PowerBI template? We cannot seem to get it working at the moment. Br. Jonas