Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have the same issue. Is there any update?
ADF Power query says invalid or missing credentials
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
Indrajit Roy
1
Reputation point
I am using ADF Power query to connect Azure sql db and fetch data.
Dataset defined for power query is built on linked service which connects the azure sql db via ADF's managed identity.
ADF Power query says invalid or missing credentials
The underlying linked service is also used for copy activity. It connects and fetches the data fine when executed.
Please avise.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee2022-03-21T23:54:15.597+00:00 Hello @Indrajit Roy ,
Thanks for the question and using MS Q&A platform.
As per my understanding you are re-using an old Azure SQL dataset (which works fine in Copy activity) in Power query activity of ADF and you are experiencing above error. Please correct if I'm wrong.
Could you please try creating a new dataset for Azure SQL and see if you notice the same behavior? Also, please double check with other authentication types (SQL auth or Service Principal) and let us know if you still notice the same behavior with Power query activity?
Do let us know how it goes?
Thank you
-
Indrajit Roy 1 Reputation point
2022-03-24T15:23:21.68+00:00 Hi @KranthiPakala-MSFT ,
I created new linked service once with ADF managed id and next with service principal.
In both the cases, I am getting credential error when trying to use in ADF power query datasets.when I do test connection on the linked service, they show connection fine.
In this case I need to connect via managed id or service principal.
sql auth can't be used.Please suggest.
-
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
2022-03-24T23:01:18.663+00:00 Hello @Indrajit Roy ,
Thanks for response, we are trying to reproduce the problem and will escalate to respective product owners if we notice this as an issue on the product side.
Will keep you posted as soon as we have further updates from our analysis.
Thank you for your patience -
Indrajit Roy 1 Reputation point
2022-03-28T05:45:46.017+00:00 Hi @KranthiPakala-MSFT ,
Is there any update on this please? -
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
2022-04-07T21:08:54.45+00:00 Hello @Indrajit Roy ,
Sorry for the delay. This issue requires a deeper investigation. If you have a support plan, we recommend to file a support ticket. In case if you don't have a support plan, please let us know here.
Thanks
-
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
2022-04-11T18:26:56.377+00:00 Hello @Indrajit Roy ,
Just wanted to check if you have got a chance to see this thread where a similar issue has been discussed - Azure Data Factory Power Query error: "We could not evaluate this query due to invalid or missing credentials"
Let us know how it goes.
Sign in to comment