The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I saw a similar question, but unanswered response for this subject. We want to embed a simple power app into some various power bi dashboards / reports that will capture current user information and record that data into a sharepoint list. It is simply the user, user email, current datetime. But we also want to include the current report name. The data is being saved as soon as the report opens. Is there a way to include the current report name? How would I get access to that? If the power app is going to be imbedded into three different reports (ReportA, ReportB, ReportC), how can I get that Power BI name and include it in the patch statement in the power app?
Thanks for any information and help
Solved! Go to Solution.
Hi @guyatisk
Here's a strategy to address this:
Use Power BI Parameters or Filters as a Workaround
One method to pass dynamic content, such as the report name, to an embedded Power App is by utilizing Power BI's ability to pass parameters or filter values to the Power App visual. You could:
Create a Report-Level Filter or Parameter: This would represent the report's name. Since Power BI does not dynamically expose the report name to embedded content, you'd manually set this parameter or filter for each report (ReportA, ReportB, ReportC).
Pass the Parameter to Power Apps: When configuring the Power Apps visual in your report, include this parameter or a distinct value that identifies the report. This way, when the app is loaded within a specific report, it receives the report name or identifier as part of its data context.
Patch(
SharePointListName,
Defaults(SharePointListName),
{
Title: User().FullName,
Email: User().Email,
DateTime: Now(),
ReportName: YourVariableHoldingReportName
}
)
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @guyatisk
Here's a strategy to address this:
Use Power BI Parameters or Filters as a Workaround
One method to pass dynamic content, such as the report name, to an embedded Power App is by utilizing Power BI's ability to pass parameters or filter values to the Power App visual. You could:
Create a Report-Level Filter or Parameter: This would represent the report's name. Since Power BI does not dynamically expose the report name to embedded content, you'd manually set this parameter or filter for each report (ReportA, ReportB, ReportC).
Pass the Parameter to Power Apps: When configuring the Power Apps visual in your report, include this parameter or a distinct value that identifies the report. This way, when the app is loaded within a specific report, it receives the report name or identifier as part of its data context.
Patch(
SharePointListName,
Defaults(SharePointListName),
{
Title: User().FullName,
Email: User().Email,
DateTime: Now(),
ReportName: YourVariableHoldingReportName
}
)
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.