News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Getting your data in P...

Power Apps - Building Power Apps

Unanswered

Getting your data in PowerApps

Like (0) Share

Report

Report

Posted on 8 Dec 2023 21:30:52 by aftabp

24

Hi,

There are lots of posts on this issue and i have tried the suggestions but still the issue for me is not resolved.

I have a PBI rapport set up in the following way.

The Table is live so that every change is visible as soon as the Save button the PowerApp is hit.

The issue is that when i click on a record/line one of the following happens:

PowerApps load the data so that i can write stuff in it and save it in DVH
PowerApps doesnt even try (no spinning wheel at all) and shows: "Getting your data"
PowerApps try to load the data (i can see the spinning wheel) but it gives up and leaves me with "Getting your data"

There are couple of things i have done to try to solve the issue:

Use the hambuger menu to reduce the size of data shown
On OnStart for App i have added:

Refresh('MSSQL Datasource');;

There are 2 forms and for each of them, the following for OnSelect

ResetForm(Name of form)

Categories:

Connecting to Data

All responses Img

All responses (5)

Answers Img

Answers (0)

aftabp 24 on 14 Dec 2023 at 09:34:40

Like (0)

Report

Re: Getting your data in PowerApps

So, my LiveTabel had columns from both liveTabel and factTabel
I have removed the columns from factTabel that i was showing in the liveTabel view. This improved the app a bit.
aftabp 24 on 14 Dec 2023 at 09:26:52

Like (0)

Report

Re: Getting your data in PowerApps

@Ethan_R That is done already
Ethan_009 4,838 Moderator on 09 Dec 2023 at 13:07:16

Like (0)

Report

Re: Getting your data in PowerApps

Hi @aftabp ,

If you have a form in PowerApps and it shows "Getting your data" and you do not see the data it means its waiting for the Form command to load which you might have not passed.

To initiate the Form for creating new Record, use 'NewForm(<FormName>);' in PowerApps and for updating existing record use 'EditForm(<FormName>);' (Make sure you pass the Record in the 'Item' property of the Form to show related details.

Hope this helps
aftabp 24 on 09 Dec 2023 at 00:53:56

Like (0)

Report

Re: Getting your data in PowerApps

No measure filter on PowerApps
lbendlin 8,077 Super User 2025 Season 2 on 09 Dec 2023 at 00:24:57

Like (0)

Report

Re: Getting your data in PowerApps

Do you have a measure filter on the PowerApps visual that makes sure it is only active when a single row in the table visual is selected?