Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
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]')
})
);
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.