How to fill in blank data using another source.

[AmirulAzim]

Hi everyone. I just started using Power BI and have created a dashboard. The data I use is from Sharepoint List. After I created the dashboard, I found out there are missing values in my data. My questions is can I fill the blank data using data from Excel file?

Regards,

Amirul.

[mohdasaad94]

Yes, you can fill in blank data in Power BI using data from an Excel file. Here are the steps to do this:

1. Import the Excel file data into Power BI: Go to Home > Get Data > Excel, and then select the Excel file you want to use. Follow the prompts to import the data into Power BI.

2. Create a new table in Power BI: Go to Modeling > New Table, and then create a new table that contains the missing data. For example, if you have missing values in a "Sales" column, create a new table that has the same column name and contains the missing values.

3. Merge the new table with the existing data: Go to Modeling > New Column, and then select "Merge Queries" from the drop-down menu. Choose the existing table and the new table you created, and then select the column you want to merge on. This will create a new table that combines the missing data with the existing data.

4. Replace the existing data with the new merged data: Go to Home > Edit Queries, and then select the merged table. From the drop-down menu, select "Replace Current" to replace the existing data with the new merged data.

5. Refresh the data: Go to Home > Refresh, and then refresh the data to see the changes.

Once you have completed these steps, the missing data should be filled in with the data from the Excel file.