Forum Discussion
TableName[ColumnName] to ColumnName when Inserting Table from Semantic Model in Excel
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