Introduction This blog walks you through how you can use PowerApps in Power BI to save a snapshot of data available in a Power BI Report. In addition, we will add the option to add a comment.
Key items covered: - Walk through an existing Power BI Report and the prep work it needs - Create the Common Data Service (CDS) entities - Create the PowerApps form using Power BI Integration - Add the CDS entities to the report
The video walks you through all the key items mentioned above. In addition here are the expressions/formulas incase you want to copy and paste. I've also provided important screenshots
The AddScreen OnStart. This is where you set the variable and the collections to temporarily store the data. The collections also provides you the correct column names to create the final expression.
This is a step-by-step video which walks you through how to build the Power BI Integration
Now for the first time you can see how filtered data from a table visualization can be saved to a data source with a click of a button. If you wish, you can also add comments as described in this blog. Finally, now that you have seen how data from a particular time-stamp can be saved in a data source, you can take this data and build your own aging report.