Error in Power BI report with SSAS live connection

[amarsale85]

Hi Experts,

I created a Power BI report with Live connection to SSAS Tabular database. 

This report displays column "ActionTitle" which i published it to Power BI service.

Now i changed the column name of "ActionTitle" to "Title" in XMLA script of SSAS model and executed it. Processed it.

This change causes the table visual in same report to fail in Power BI service (as shown below).

So the requirement was to customize the column names according to the customer's needs which is why for Customer#1 the same column could be named "ActionTitle" in SSAS DB1, the same column for Customer#2 could be named "Title" in SSAS DB2.

Regards,

Amar

[amarsale85]

I don't want to manually edit it for each customer. It should be dynamic based on some parameter. If i have all these personalizations/customizations stored in the DB is there a way i could add condition for column headers to change according to customer viewing it ?

[GilbertQ]

Hi there

Currently that is not possible to complete. The values that are stored when the data is imported into the dataset is how they remain.

You could look to vote for an idea at https://ideas.powerbi.com

[GilbertQ]

Hi there

If you make a change to the column name, you will have to update the PBIX report with the new column name.

From your example you have 2 different SSAS databases, so there would be 2 different PBIX reports?

[amarsale85]

Its same database for each customer. The requirement is that a customer can change the name of any column/field. If the customer wants to change the name of field "Title" to "ActionTitle" so the report have "Title" will fail as it doesn't exist now after the change. But i know the PBIX file is static and will need to be re-created. Thank you anyways. 

[GilbertQ]

Hi there

If it is in the same database then you could potentially change it in an individual PBIX where you can rename the column once it is put into a visual?