Forum Discussion

Element115's avatar
Element115
Memorable Member
2 years ago

BUG::New table in data warehouse not detected

STEPS 0__create a new data warehouse 1__create a new table in schema [dbo] (with column data types matching or compatible with on-prem SQL Server 2017 source) 2__wait, then refresh until table app...
Dataflows
frlunett's avatar
frlunett
Microsoft Employee
2 years ago

From our telemetry it does seem like a gateway connectivity issue. Can you check the error message that's shown when you click on the Sector_TS_* activity from the refresh history dialog?

 

We do have a blog post that describes limitations and considerations when using Data Gateway with output destination in the context of Dataflow Gen2: On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

 

Finally, it is by design to disallow publishing a dataflow that only contains queries that are not marked as staged nor have an output destination set.

 

Thanks,
Frank.

Element115's avatar
Element115
Memorable Member
2 years ago

Thanks Frank, sorry for the late reply as I got distracted by all the other support tickets opened.  The data gateway works fine, well at least with the Power BI Service, the right ports are opened in the firewall and so on.  Let's pause the data warehouse issue for now as all the issues concerning data ingestion in the lakehouse are being worked on.