Forum Discussion

jadhalaoui's avatar
jadhalaoui
Icon for Helper I rankHelper I
5 years ago
Solved

Adding New Columns to Dataset from RedShift Warehouse Without Breaking my Analysis

Hello - this community has been of great help to in learning PowerBI from scratch. I have been able to create some very powerful dashboards thanks to your generosity with your time and knowledge-sharing.

 

Question

How do I insert new columns to a warehouse from which my data source is imported without causing the measures created to break?

 

Concern

I have created over 150 explicit measures. All are dependent on data from transformed and duplicated columns.

Based on my analysis, I have realized we must add new columns to our Data Source.

My research of the community forums shows that inserting columns can be problematic.

 

Boundaries

Before I request that our tech team update the warehouse and cause my datasets to break, I would like to know the right way to do so and still preserve all the custom measures that I have created.

 

Warehouse

Amazon Redshift

 

Manipulation

All Manipulation I did was in the Transform Data tab of PowerBI

 

Thank you,

  • jadhalaoui . Open transform data/edit query. Right click on the table name and open advance editor. If you see a column list, Go ahead and add the required column.

     

    Keep a backup of file.

2 Replies

  • jadhalaoui . Open transform data/edit query. Right click on the table name and open advance editor. If you see a column list, Go ahead and add the required column.

     

    Keep a backup of file.

    • jadhalaoui's avatar
      jadhalaoui
      Icon for Helper I rankHelper I

      Thank you Amit for your quick response.

       

      This works!