Help on Power BI and Power App integration

[Patronez]

Hi everyone!

I have a physical archive managed by an external vendor. I've created a Power BI database with 100% of the archive's contents and I'm comparing it weekly with a report the vendor sends me on their document cataloging progress. I added a page with a table showing the cataloged boxes, including the vendor's document descriptions.

I want the teams responsible for each box to provide feedback on the descriptions using a Power App embedded in the Power BI report.

I've inserted an editable form in the Power App, connected to a blank Excel file on SharePoint. The Excel file has four columns: Box ID, Responsible Area, Description Makes Sense (Yes/No), and Comments.

I want the app to pre-populate the Box ID and Responsible Area fields from the Power BI data, allowing users to manually complete the remaining two fields. Both the Power BI dataset and the SharePoint Excel file use "CONCAT BOX" as the Box ID field name.

However, I'm still getting an error and can't figure out how to fix it.

Can anyone help me troubleshoot this?

[lbendlin]

Your Power BI visual failed to provide a value for [CONCAT BOX] to the PowerApps service.

[Patronez]

Are there any other way to get data from PBI to PowerApp? Video below explain the process I've tried, but I don't know if because I have CONCAT BOX data in 3 tables in PBI, the lookup formula didn't work.
(217) Can’t INPUT DATA in Power BI? Here is a WRITE BACK Option with Power Apps! - YouTube

[lbendlin]

Example:

ClearCollect(colProjectsRaw, PowerBI.ExecuteDatasetQuery(
    "aaaaaaaa-bbbb-cccc-dddd-1234567890ab", /*Workspace GUID*/
    "bbbbbbbb-cccc-dddd-eeee-1234567890ab", /*Dataset GUID*/

    "EVALUATE
        SELECTCOLUMNS(VALUES('Projects'),
            'Projects'[ID],
            'Projects'[Description],
            'Projects'[Project_Manager])
        ORDER BY 'Projects'[ID] DESC"
    ).firstTableRows
);

ClearCollect(colProjects,
    ForAll(colProjectsRaw, {
        ID: Text(ThisRecord.Value.'Projects[ID]'),
        ProjectManager: Text(ThisRecord.Value.'Projects[Project_Manager]'),
        Description: Text(ThisRecord.Value.'Projects[Description]')
    })
);