ETL Mechanism

[Anonymous]

How to incorporate the change in data source (let say a excel file changes the no of columns) into dashboard? Do the whole dashboard needs to be redone to match the new data or it can be improvised upon? 

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

If I undersand your scenario correctly that you create a report with Excel file in Power BI Desktop and then you remove or add one column in excel?

If you remove the column in excel, you need to refresh the data data source and delete the column in "Changed type" step in Query editor.

If you add the column in excel, you only need to click Refresh button in Power BI and then it will update the data source.

If I misunderstood your scenario, please describe your scenario in more details with screenshots.

Best Regards,

Cherry