Data flow power query source field recognition issues

George Bryant 1

I have a source of an Azure SQL Server which i am trying to utilise a Data Factory power query against. I can build the applied steps out comfortably, it works in preview mode perfectly however i get an error at the top about the field i am referencing. I am using the field and the steps show up and work however i am unable to use it because of this error. It is frustrating because I can clearly see the field and the steps applied to it and clearly working.

Am i missing something? Ive checked about every setting and retested multiple times with no answer

George Bryant 1 Reputation point

2021-03-24T00:04:23.673+00:00

It should be pointed out that this query works in Power BI M, just very specifically not in Data Factory

1 answer

Nalini Nara 1 Reputation point

2021-03-23T23:19:43.113+00:00

@George Bryant , Did you try editing the schema or doing any transformations in the source? When you expand ADFResource, all the sources you have selected in the power query settings will show up here. These datasets are read-only and are not expected to be modified. Any transformations you intend to do should be performed on the user query.

Let us know if doing all transformations on user query solves the issue.
Please sign in to rate this answer.
George Bryant 1 Reputation point

2021-03-23T23:24:25.58+00:00

Hi
Yes I am doing all my logic in the user query. It is when creating in user query specifically that it has this error.

Nalini Nara 1 Reputation point

2021-03-24T01:17:33.893+00:00

Hi,
Is it possible that you have changed the PromoteHeaders setting on the dataset after doing some transformations in the powerquery? The setting I am referring to is at the source dataset level and is called "First row as header". This needs to be checked before using it inside power query transformations. If this does not help resolve the issue, please file a support ticket and one of us will reach out to you.

George Bryant 1 Reputation point

2021-03-24T14:54:10.74+00:00

I did check that yes however because it is coming from an Azure SQL server source this would not apply here.

I will have to submit a support ticket for this as the steps applied are not the issue, it is simply an issue where Power Query is seeing the field in order to have steps used against it but still seems to not recognize that same field. This only arises in Power Query in Data Factory and not Power Query in Power BI.

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-24T19:51:23.077+00:00

Hi @George Bryant ,

Could you please share the support ticket # here with us so that we can connect with you offline to further deep dive into this issue.

We look forward to your response.

Thank you

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-03-30T01:46:35.297+00:00

Hi @George Bryant ,

We still have not heard back from you. Just wanted to check if you are still facing the issue? If so could you please share the details over email as requested in private message.

Thank you
Sign in to comment