Query fabric data warehouse

[shaunmw]

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

[shaunmw · Accepted solution]

found it - just need to use the SQL connection string and not the data warehouse connector.