Hi,
I have a data ETL running into Azure SQL on a Fabric pipeline and dataflow gen2.
In the power query (dataflow gen2) i run a query against the SQL table for as below:
chk = Sql.Database("xxxx.database.windows.net", "DB Name", [Query="SELECT * FROM endpoints WHERE freq '1'"]),
I'm looking at migrating to the Fabric data warehouse and updating the dataflows to save to the data warehouse instead of SQL.
I can call the Fabric data warehouse table as a data source in the data flow with no problem:
tmp = Fabric.Warehouse([]){[workspaceId = "xxxxx"]}[Data]{[warehouseId = "xxxxxxx"]}[Data]{[Schema = "dbo", Item = "Endpoints"]}[Data]
but when i try run a select query against it like i can with the SQL data source:
tmp = Fabric.Warehouse([]){[workspaceId = "xxxxx"]}[Data]{[warehouseId = "xxxxxxx"]}[Data]{[Schema = "dbo", Item = "Endpoints"]}[Data]{[Query="SELECT * from endpoints where freq = '1'"]},
it returns the error below
Expression.Error: The key didn't match any rows in the table.
Details
Reason = Expression.Error
Key = [Query = "SELECT * from Endpoints where freq = '1'"]
Is it possible to run a select against the Fabric datawarehouse in power query as i can with sql? If so then what is the required syntax to do this.
Thanks in advance
