Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Patronez
New Member

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?PBI_table_connections.pngPowerApp_PBI_error.png

3 REPLIES 3
lbendlin
Super User
Super User

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

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

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.