Forum Discussion
TableName[ColumnName] to ColumnName when Inserting Table from Semantic Model in Excel
Hi team, I'm inserting a table of data from my semantic model published in Fabric within Excel, through the following steps: On the Data tab click on Get Data > From Power Platform > From Power...
Hi Dan44
If you had to connect directly to the semantic model, you should be able to just get the name as you need or what is being displayed.
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
GilbertQ I'm aware thats an option thanks but I want to avoid that Analyze in Excel approach. Basically because it's a pivot table, unless the user specifically has access to the semantic model, when they try and manually filter the pivot table it will throw an error. Regardless of if there's permissions meanwhile, it will always throw an error if the Excel report is published to a workspace.
However it seems the price for pulling the data into the table option is to always display the table name in the headers...
