Data Factory Power Query query result sink option missing

Question

Data Factory Power Query query result sink option missing

Zac Connolly 45

Hi, Im struggling to find the query result options in the sink for power query?

I haven't changed anything in the pipeline and when I've logged in today the option is no longer there. I've loaded other factories and its missing across all of them, has the been an update?

User's image

Johan Lezwijn 5 Reputation points

2025-01-21T09:29:09.4633333+00:00

Hello, the options mentioned are not the answer on the question. The missing options cannot be found somewhere else.
Chandra Boorla 14,680 Reputation points Microsoft External Staff Moderator

2025-01-22T22:05:09.25+00:00

Hi @Zac Connolly

Just checking in to see if the below answer provided by @ Sina Salam helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

1 additional answer

Your answer

Johan Lezwijn 5 Reputation points

2025-01-21T09:29:09.4633333+00:00

Hello, the options mentioned are not the answer on the question. The missing options cannot be found somewhere else.
Chandra Boorla 14,680 Reputation points Microsoft External Staff Moderator

2025-01-22T22:05:09.25+00:00

Hi @Zac Connolly

Just checking in to see if the below answer provided by @ Sina Salam helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Sina Salam 22,031 Volunteer Moderator

Hello Zac Connolly,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that Power Query result sink option missing in Data Factory.

That's highly frustrating, there have been some changes in Azure Data Factory that might be affecting your experience. But there are way out:

The sink dataset selection might have moved. You can now set your sink dataset when you add the Power Query activity to your pipeline - Check out this similar accepted answer in your case. - https://learn.microsoft.com/en-us/answers/questions/395632/sink-datasource-missing-in-azure-data-factory-powe?page=1
The Power Query activity interface has been updated. You can now find the sink options under the "Sink" tab within the Power Query activity settings. - https://learn.microsoft.com/en-us/azure/data-factory/control-flow-power-query-activity
If these steps don't resolve your issue, check the official documentation in this link: - https://learn.microsoft.com/en-us/azure/data-factory/control-flow-power-query-activity

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

Chandra Boorla 14,680 Reputation points Microsoft External Staff Moderator

2025-01-23T21:47:36.22+00:00

Hi @Zac Connolly

Just checking in to see if the above answer provided by @ Sina Salam helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Zac Connolly 45 Reputation points

2025-01-27T09:47:10.9366667+00:00

No this hasn't solved the problem. Refers to documentation stating the location of the sink options changed, the documentation states the same location I am looking at where mine is missing.
Chandra Boorla 14,680 Reputation points Microsoft External Staff Moderator

2025-01-29T16:52:20.8066667+00:00

@ Zac Connolly

For further details, please refer to the similar thread below.

https://learn.microsoft.com/en-us/answers/questions/2150820/adf-power-query-sink-settings-ui-missing-options
Chandra Boorla 14,680 Reputation points Microsoft External Staff Moderator

2025-01-30T16:30:27.3166667+00:00

@ Zac Connolly

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Zac Connolly 45 Reputation points

2025-01-30T16:40:13.47+00:00

Chandra Boorla The responses state the same issue and provide no resolution only that it has been sent to the product team.

I've already provided an answer to the question... you would have been better off linking my answer on the other post than linking nonsense on here.
Chandra Boorla 14,680 Reputation points Microsoft External Staff Moderator

2025-01-30T17:40:04.9366667+00:00

@ Zac Connolly

Thank you for your feedback, and I appreciate you bringing this up. I understand your concerns, and I sincerely apologize if the response wasn’t as helpful as it could have been.

Your solution is indeed valuable and linking it to other relevant posts would have been a better approach. I’ll take this as an opportunity to improve future responses.

We will contact the product team to address the issue and share the insights that you have provided.

Thank you again for your input, and I appreciate your contributions to the discussion!

Answer 2

Zac Connolly 45

If anyone else has this issue, its something to do with the formatting on the webpage. If you click on query name box and then press tab, it will move through the different options available on the page. You'll see that the sink options button is hidden behind the sink dataset element on the page. Its the second option hidden behind the element, press enter and it will open. User's image

I've changed my aspect ratio of the screen and tried to resize, no luck.

Share via

Data Factory Power Query query result sink option missing

1 additional answer

Your answer