Power App Widget display information differently in Power BI vs Power app

[selenium]

Hi All,

I have a Power app which I have included in Power BI dashboard using the Power app widget.

What does the app do?

The app gets activated when a record in Power BI table is selected and it allow users to key in their remarks for the selected record and the remarks get store in a Sharepoint list.

Green box shows the form drawing information from Sharepoint list to display the latest record based on reference key and reporting month of the selected record. Sharepoint list may have multiple records with the same Reference Key and reporting month.

View in Power BI dis not show the latest record

however when I edit the app and it open up in power app page the remarks are showing. 

Any idea why the behaviour is different? based on filter by reference key and reporting month the number of records is <100 records. How can i fix this?

Thank you in advanced!

[v-hashadapu]

Hi @selenium , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

[v-hashadapu]

Hi @selenium , Hope you are doing well. Kindly let us know if the issue has been resolved or if further assistance is needed. Your input could be helpful to others in the community.

[v-hashadapu]

Hi @selenium , I hope you're doing well! Just checking in to see if you had a chance to review the details shared earlier. If any of the information addressed your needs, feel free to mark it as "Accept as Solution"  to help others in the community. Please let me know if you have any further questions!

[v-hashadapu]

Hi @selenium , I wanted to check with you and see if the provided information was useful. If any of it helped resolve your question, consider marking it as "Accept as Solution" to make it easier for others to find. Let me know if there's anything else I can assist with!

[v-hashadapu]

Hi @selenium , Thank you for reaching out to the Microsoft Community Forum.

This isn't a bug, it's expected behavior when embedding a Power App inside a Power BI report. Power Apps doesn't automatically refresh data from SharePoint after a new remark is added unless you explicitly tell it to. That’s why the latest remarks appear in Power Apps Studio but not in the embedded view inside Power BI.

To fix this, add Refresh(YourSharePointList) in the app’s OnVisible property or immediately after submitting a new remark. Also, ensure you're setting the selected record from Power BI like this: Set(selectedRecord, First(PowerBIIntegration.Data)) and use it in your filter to fetch remarks.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[selenium]

Hi v-hashadapu,

Sorry for the late reply. I was trying what you have suggested but still face the same issue.

I have set OnVisible to be: 

    Set(selectedRecord, First(PowerBIIntegration.Data));

    Refresh('SharePoint List Name');

However, no records is being captured when using selectedRecord.variable name. but works with 

First(PowerBIIntegration.Data).'variable name'.

I have also set Refresh('SharePoint List Name'); in On visible and after Patch(...), result is the same. Showing in Power Apps but not in Power BI.

Originally the latest records are showing but not too sure what happen its no longer showing the latest record.

Best regards,

Selenium

[v-hashadapu]

Hi @selenium , Thank you for reaching out to the Microsoft Community Forum.

In embedded mode, OnVisible doesn’t always run again unless the user selects a different record, which means your updated data isn’t getting pulled in unless explicitly reloaded. A more reliable approach is to skip using selectedRecord and instead reference First(PowerBIIntegration.Data) directly in your filters. After the Patch(), add a short pause, refresh the SharePoint list and then use ClearCollect() to reload the latest data:

Patch('YourSharePointList', ...);

Refresh('YourSharePointList');

Pause(1);

ClearCollect(

    LatestRemarks,

    SortByColumns(

        Filter(

            'YourSharePointList',

            RefKey = First(PowerBIIntegration.Data).RefKey &&

            ReportingMonth = First(PowerBIIntegration.Data).ReportingMonth

        ),

        "Modified", Descending

    )

);

Bind your display controls (or form Item) to First(LatestRemarks) and reset the form if needed. Also include this ClearCollect() in the screen’s OnVisible, though keep in mind it won’t always re-run in embedded mode unless a new record is selected.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[selenium]

Hi v-hashadapu,

I've tried, the method you have suggested requires a Pause function which is not available in power apps.  I do already have a ClearCollect, result is the same. Seems like the behaviour in embedded mode varies.

Best Regards,

Selenium

[v-hashadapu]

Hi @selenium , Thank you for reaching out to the Microsoft Community Forum.

Ensure that your data is refreshed and reloaded immediately after the user submits the remark, not just when a record is selected. In embedded mode, Power Apps doesn’t re-trigger data logic automatically if the same row stays selected, which is why it appears to work in Power Apps Studio but not inside Power BI.

By reloading the SharePoint data right after submission, within the same flow and making sure your form or display control is bound to that refreshed data, the latest remark will consistently appear. This works reliably in both Studio and embedded mode, without needing any delays, timers, or extra workarounds.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.