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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
JE_test
Resolver I
Resolver I

Unable to access stored procedure from warehouse in pipeline

Hi!

I'm unable to use my SP from a Warehouse in a pipeline. 

JE_test_0-1700734014491.png

If I click on "More" I get the following error message:

"undefined. Activity ID: undefined."

 

I have re-created the warehouse to see if that made a difference, but it did not. 

Any ideas on how to resolve this?

1 ACCEPTED SOLUTION
JE_test
Resolver I
Resolver I

I was later able to use my stored procedure by just typing its name manually instead of using the dropdown. It seems like only the dropdown is broken.

View solution in original post

3 REPLIES 3
JE_test
Resolver I
Resolver I

I was later able to use my stored procedure by just typing its name manually instead of using the dropdown. It seems like only the dropdown is broken.

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

v-nikhilan-msft
Community Support
Community Support

Hi @JE_test 
Thanks for using Fabric Community.
Apologies for the issue you are facing. Can you please try the below method? I have attached the screenshots.

Click the open button. This opens the warehouse. If your stored procedure is successfully created in the warehouse, it will be shown in the warehouse.

vnikhilanmsft_0-1700754040461.png

If you are able to see the stored procedure in your warehouse and still not able to select in the pipeline level, there might be some issue with the stored procedure code.

Can you try creating a default stored procedure and check if you are able to access it in the pipeline?
1) Click on new stored procedure.

vnikhilanmsft_1-1700754354548.png

2) Run the query. A stored procedure gets created in the warehouse.

vnikhilanmsft_2-1700754407371.png

3) Check whether you are able to access this stored procedure. Please let me know if you have any further issues.


Thanks.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!