Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
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...