Error when trying to retrieve data from the network error in look up

(0) Share

Report

Posted on by Knut_Petter_D

Hi.. I'm trying to build at PowerApp to edit a table inside PowerBi..

To do so, I need to connect the data source to PowerApps not just PowerBi. This so I can write data back.

I have a gallary page whit the readonly data from PowerBi on landing.

Uten navn.png

And to a edit page to write the data to the data source itself.

To get the actual datapoint the user whants to edit, i put in this formula in Item on the edit form

And here is where I get the error.. "Error when trying to retrieve data from the network"

If I edit the formula, and set the ID colum in the tabel it search. I get the right retur of the ID.. But the rest of the field dont have any data then..

I GOOGLE'D the **bleep** out of my computer, but I cant seem to find the rigth way to fix it..

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Knut_Petter_D

Try LookUp(tblUtstyrsoversikt; ID=Gallery1.Selected.ID)

Was this reply helpful? Yes No
Knut_Petter_D 5 on at

Like
a
(0)

Report
Copy link

Link copied!

That is the formula I use, sorry i see the picture is "ID" in. That was my second try to force PowerApps to read it as tekst.. But still. Same error.. 😕

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Knut_Petter_D

Your gallery shows an error. What was it? You will need to fix that first. Also in the ">" icon make sure there is an EditForm(Form1) function in it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Knut_Petter_D
What worked for me is :
To build reports I usually use Power BI DESKTOP.
And in desktop version I am getting blank data in Power Apps (using PowerBIIntegration.Data).

Solution:
I have Published my desktop version to Power BI SERVICES (powerbi.com).
And from my workspace I have went to Report and started Editing report and Power Apps visual.
Connection is working perfectly here.

Hope it helps!

Was this reply helpful? Yes No