Forum Discussion
Solved
Edit and preserve column headers in connected table
Hi, I have an issue with changing column headers in a table in Excel. after reading this Design refreshable reports in Excel with Power BI data - Power BI | Microsoft Learn I found this to be ...
You need to distinguish between two scenarios
#1 Run a DAX query against a semantic model. For that you connect to "Power BI Semantic Model". You won't be able to change/remove the table names
#2 Import data from a SSAS cube ("Analysis Services Database"), by specifying the same DAX query. This will result in a Power Query connection where you can then add steps to remove the table names and do other manipulations.
lbendlin
Super User
Super UserBut from my understanding, this requires the main table to be present in the Excel file. Leading to duplicate data.Please elaborate. Can you show an example?