Fabric: Warehouse impossible to select in lookup activity

Hello,

 

I am currently trying to set up incremental refresh using pipelines in Fabric. I need to use the lookup activity (as shown in several tutorial). But everytime I can't see any warehouse in the dropdown list to select it (in settings I choose workspace, Warehouse, and the drop down list is alsways empty, despite the fact that I have warehouses with tables in my worspace). Is there a bug?

Investigating
Comments
avatar user
Anonymous
Not applicable

Hi @MylenePBI ,

 

Please check your problem by the following methods:

1.Make sure that your Fabric workspace is correctly connected to your data warehouse. You should be able to see your data warehouse under the ‘Connections’ tab in your Fabric workspace. If not, you may need to re-establish the connection.

2.Sometimes, refreshing your workspace can help update the list of available resources. Try refreshing your workspace and then check the dropdown list again.

3.Ensure that you have the necessary permissions to access the data warehouse from your Fabric workspace. If you don’t have the necessary permissions, you won’t be able to see the warehouse in the dropdown list.

4.Make sure that your data warehouse is active and not paused or offline. If your warehouse is not active, it won’t appear in the dropdown list.

 

For more you may refer to:

 Incrementally load data from Data Warehouse to Lakehouse - Microsoft Fabric | Microsoft Learn

 

Best regards.
Community Support Team_Caitlyn

MylenePBI
Helper I

Hello, everything works fine now! I don't know what happened...