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 ,
I don't think you have much options left.If you want to try alternate approaches you can check this -
You can use run a query against dataset in power automate and you will be able to pull the data with user defined column names in dax.
You can load data to a dataflow and apply your transformations then your users can access the data from Excel and can import the data.
Thanks,
Sai Teja
Hi there
Just remember that there is a limit for using the DAX query to export in Power Automate.
The only other workaround is to use PowerShell or Fabric to extract the data.