Forum Discussion

jokrra89's avatar
jokrra89
Frequent Visitor
1 year ago
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 ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jokrra89,

Thanks for reaching out to the Microsoft fabric community forum.

 

It looks like you were facing issues related to column header in a table. If the solution provided by lbendlin works for you then please accept it as solution.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.