Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
GregMarbais
Advocate V
Advocate V

Stored Procedure Missing Warehouses

I'm running into an issue where I've created a stored procedure in a Data Warehouse and created a pipeline but when I add the Stored Procedure activity to the data pipeline, I'm not seeing any of my warehouses - I only see the staging warehouse. I've watched several other videos where people are actually seeing their warehouses. My warehouses are all in the same workspace. So I'm not sure what I'm missing.

 

Is there a configuration that I've missed?

Stored Procedure Missing Warehouses.png

1 ACCEPTED SOLUTION
v-nikhilan-msft
Community Support
Community Support

Hi @GregMarbais 
Thanks for using Fabric Community. Apologies for the issue you have been facing.
Can you please try adding dynamic content as mentioned in the below steps?

vnikhilanmsft_0-1702484961417.png

Give the name of the warehouse that you want to use.

vnikhilanmsft_1-1702484995703.png

Get the sql endpoint connection string from the warehouse settings and paste it in the SQL connection string.

vnikhilanmsft_2-1702485084114.png


Click on the refresh button.

vnikhilanmsft_3-1702485176375.png

You will be able to view the stored procedures present in the warehouse.

vnikhilanmsft_4-1702485215330.png


Hope this helps. Please let me know if you have any further queries.

 

View solution in original post

3 REPLIES 3
v-nikhilan-msft
Community Support
Community Support

Hi @GregMarbais 
Thanks for using Fabric Community. Apologies for the issue you have been facing.
Can you please try adding dynamic content as mentioned in the below steps?

vnikhilanmsft_0-1702484961417.png

Give the name of the warehouse that you want to use.

vnikhilanmsft_1-1702484995703.png

Get the sql endpoint connection string from the warehouse settings and paste it in the SQL connection string.

vnikhilanmsft_2-1702485084114.png


Click on the refresh button.

vnikhilanmsft_3-1702485176375.png

You will be able to view the stored procedures present in the warehouse.

vnikhilanmsft_4-1702485215330.png


Hope this helps. Please let me know if you have any further queries.

 

That worked, thanks!

Hi @GregMarbais 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024 FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.