Forum Discussion
TableName[ColumnName] to ColumnName when Inserting Table from Semantic Model in Excel
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.
SaiTejaTalasila thanks for your suggestions. Is it the case however you cannot select a Dataflow Gen2 with the Get Data, From Power Platform, Dataflows? Essentially the issue I'm dealing with is I have the following Office Script which I am scheduling:
function main(workbook: ExcelScript.Workbook) { workbook.refreshAllDataConnections(); }The scheduling only works when my data is brought through by Analyze in Excel or Get Data, From PowerPlatform where I connect to the semantic model (which I am currently doing). If I however connect to the SQL Analytics Endpoint through Power Query (using the SQL string) of my lakehouse, and load the data to the worksheet, the above script will not run (at least when it is scheduled as it works when manually run). Note I have another active post on this issue:
Hi Dan44 ,
If you are looking for an alternative approaches you can check my ideas they will be able to do the job.You check semantic link and I think you have fabric capacity based on your comments.
https://learn.microsoft.com/en-us/fabric/data-science/semantic-link-overview
Power automate run a query against dataset
In dax alias is possible
NewTable =
SELECTCOLUMNS(
ExistingTable,
"NewColumnName1", [ExistingColumnName1],
"NewColumnName2", [ExistingColumnName
2]
)
Thanks,
Sai Teja
