Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Shivateja
Regular Visitor

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

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

3 REPLIES 3
SaiTejaTalasila
Solution Sage
Solution Sage

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. Click the gear icon to edit the expand step.
    2. Uncheck the "Use original column name as prefix" option before expanding the columnsimages.png

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

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...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.