Forum Discussion

Patronez's avatar
Patronez
Regular Visitor
1 year ago

Help on Power BI and Power App integration

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?

Need Help
Tutorial Requests

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        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]')
    })
);