Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
9 years ago

SSAS Tabular 2016-renaming columns breaks references?

I was under the (wrong?) impression that SSAS Tabular 2016 would support renaming columns and or measures because the presentation layer was supposed to use uniqiue IDs.

 

That is to say: I could have a column called Tot_Sales and I could rename it "Total Sales" and my reports would just work because they would reference by ID not name?

 

Or a measure TotYTDSales could be "Sales Total YTD" and again, ref by ID not name so it would still work.

 

However, this does not seem to be the case.

 

Is this by design?

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    OneWithQuestion

     

    In Analysis Services, renaming columns will not break the reference within model. However, at presentation level, it may not updated to reporting tools. So if you rename a column in your tabular model, I suggest you re-import or re-open connection to SSAS tabular in Power BI Desktop.

     

    Regards,