cannot load data in PowerAPPs app integrated in PowerBI report page

(1) Share

Report

Posted on by GGG666

190

Hi all Experts

I created a PowerBI report. I need input different commnets based on different slicers ‘ results . I added Power apps visualization in Powerbi report page and select three fileds for it.

Then I went to the Powerapps editing interface to do the following settings

1 edit the data source of Edit form as “sharepoint list”

2 edit the Defualt of Category ，FY and period with code First(PowerBIIntegration.Data).'Consolidation Unit'

First(PowerBIIntegration.Data).'FY'    First(PowerBIIntegration.Data).'Period'
 
But when I run the app in PowerBI report，I receive the screenshot 3  . It is “getting  your data”

screenshot1

screenshot2

screenshot3

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

RaghavMishra 261 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

The “Getting your data…” spinner that never resolves inside the Power BI visual is almost always one of these four things — all documented on Microsoft Learn for the Power Apps visual for Power BI.

1. The app has to be saved AND published (not just saved)

The Power BI visual only renders the published version of the canvas app. After editing the data source and Default properties, in Power Apps Studio go to File → Save → Publish this version. Then re-open the Power BI report.

2. The app must be shared with the same user(s) who view the Power BI report

Per the Learn doc: “make sure to share the app with” the same people who consume the Power BI report. If the user opening the report doesn't have access to the canvas app, the visual hangs on “Getting your data”.

3. Don't exceed the 1,000-record limit from Power BI → Power Apps

The PowerBIIntegration object is capped at 1,000 records. Apply slicers/filters in Power BI so fewer than 1,000 rows flow into the visual; otherwise it can fail to load.

4. Check the data source consent for SharePoint

The first time the embedded app runs for a user, Power Apps prompts for consent to the SharePoint connection. Inside the visual that prompt is often invisible. Quick test: open the published app directly at https://apps.powerapps.com/… (sign in as the same user), grant the SharePoint connection consent, then return to the Power BI report and refresh — the visual usually loads after that.

Bonus tip on your Default formula

Your formula is correct, but to make the form react when the slicer changes, also set:

OnDataRefresh = PowerBIIntegration.Refresh(); ResetForm(Form1)

(PowerBIIntegration.Refresh() is only available if the app was created from the Power Apps visual in Power BI — not imported.)

Also remember the visual is supported only over https, in Embed for your organization, and not in anonymous embeds.

📚 Reference: Power Apps visual for Power BI — usage, sharing, and limitations (Microsoft Learn)

Found this helpful? Please mark ✅ “Does this answer your question?” so others searching for the same issue can find it quickly. A 👍 on “Was this reply helpful?” or a ♥ Like is also much appreciated!

Raghav Mishra — LinkedIn | PowerAI Labs

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @GGG666,

You’re getting this issue because your form is configured as an Edit Form, but the Item property of the form is not set correctly.

Right now, you are manually setting the Default value for each field (Category, FY, Period), which is not needed in this scenario.

Instead, you should set the Item property of the Edit Form to the selected record from PowerBIIntegration.Data. Once the form Item is configured properly, Power Apps will automatically populate all the field values.

For example, set the form’s Item property like this:

LookUp(YourTableName,ID=Text(First('PowerBIIntegration'.Data).ID))

Else just change the form mode to New form

If your form mode is new then it will always create new item in table.

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No