Problem:

The client doesn't have data engineers on the team. A lot of "dirty" data is coming from a data source that is inputted incorrectly due to human error.

Solution:

1) Create an Excel file that will be stored in an online SharePoint folder and connect it to your SQL data source. Pull all the columns that you need.

2) Create a new sheet in the same Excel file and generate a formatted table that reflects the columns you pulled from the data source. Use an Excel formula to reference the source table. As an example:

formula: =IF('main page'!A2="","",'main page'!A2)

3) Connect the PowerApps to your Excel file and add a table, form and button visual

4) Add your new PowerApps to the PBI report and clean up all the "dirty" data directly from your report.

Data Cleaning with PowerApps

Problem:

Solution: