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.
Hi jokrra89,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.