Issue with column names in summarized and underlying exports of Power BI Report

[Shivateja]

Hi Team, I am facing issue with the column names when i do summarized and underlying export for a power bi report.

The column names  have there table names as prefix .

----------->  "TableName[ColumnName]"  instead of    "ColumnName" 

How to resolve this issue.

can some one suggest the solution for this issue

[SaiTejaTalasila]

Hi,

To avoid getting the table name as a prefix in column names when combining tables in Power Query, you can use the following steps:Expand Columns Without Prefix:When you expand a column containing tables, you'll see a settings icon (a small gear icon) next to the 'Expand' step in the Applied Steps pane.

1. 1. Click the gear icon to edit the expand step.
   2. Uncheck the "Use original column name as prefix" option before expanding the columns

       

[Shivateja]

Hi,we are using Semantic layer Azure Analysis Services ,live connection to PBI 

[SaiTejaTalasila]

Hi,

In direct query it is possible and in live I don't think it is possible as you are directly accessing DMV's .https://learn.microsoft.com/en-us/analysis-services/tabular-models/rename-a-table-or-column-ssas-tab...