Forum Discussion
Edit and preserve column headers in connected table
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.
Super UserAh, you don't need Table_ExternalData_1. In Excel you can choose to create queries that do not materialize into tables. You can then decide later to create a table from the (now modified) query.
Look at the Table Source for Table Nr2. It has a reference that you need to change.
Table_ExternalData_1 is not visible in Power Query, as it comes from a connection.
I am not sure about the correct Naming, but I guess from
Design refreshable reports in Excel with Power BI data - Power BI | Microsoft Learn
that the Power BI data is connected via the XMLA endpoint.
- lbendlin
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,
Thanks for the clarification.
I am using approach #1
A combination of hacks make it possible to remove the table names:
Define column names in a selectcolumns statement in the DAX query,
use you Power Query approach to remove "[ ]".
My question is if there should be a native solution.according to
Design refreshable reports in Excel with Power BI data - Power BI | Microsoft LearnWhich refers to #1
Anyway, thank you for your insight