Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

ETL Mechanism

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 u...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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