Hi PowerBI developers,
I'm working on a project which requires the embedded powerapps in powerBI to write back the data to SharePoint.
The Powerapp works fine in one report, but now we're wondering whether it's possible to use the same powerapp as a model across multiple reports. (ex. I developed A App, embed it now in A report, then make a copy of A App- A1 App, embed A1 App in A1 report)
Now , the question is how to make the data fields passed from PowerBIIntegration 'Dynamic'?
For example, A report has 3 data fields: Report Name, Currency, and Language.
I can retrieve the data by setting the gallery source to PowerBIIntegration.data, then set text1 to ThisItem.ReportName, text2 to ThisItem.Currency, text3 to ThisItem.Language in the gallery.
But A1 report has 4 data fields: Report Name, Transportation Tool, Post Code, and City.
Instead of hard coding the fields each time according to the fields name from BI table,
are there possibilities to make the fields name 'dynamic' from BI or from powerapps side?
So each time when we embed the app model, we do not need to modify anything from the app?
Any suggestions or experiences are very welcome and appreciated!
regards,
PA user
Hi @devsyw ,
Please review the content in the following links and hope they can help you.
PowerApps Power BI Integration Dynamic Filtering
PowerBI Integration Query - Accessing passed values
PowerApps & Power BI: PowerBIDataIntegration.Data Value in New Form
Filtering data in PowerApps based on Power BI
Best Regards
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!