Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,563 questions
Trying to use power query on ADF error: "We could not evaluate this query due to 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(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)
Anonymous
Hi
I am trying to use power query on azure data factory and I am receiving the following error when I add a data source from our azure data lake: "We could not evaluate this query due to invalid or missing credentials" (see image below).
I know that I have access to the datalake and I successfully tested the connection to the lnk service. I am also able to access this database when I use power Bi desktop.
Do you have any ideas as to why I am getting this error message and how to solve it?
Thanks
Azure Data Lake Storage
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,674 questions
{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,647 Reputation points Microsoft Employee Moderator2021-11-19T15:50:29.047+00:00 Hi @Anonymous ,
Thanks for your query and using Microsoft Q&A forum.
As per the error message, it sounds like more of permission related. Could you please confirm if you were able to preview the data from ADLS gen2 dataset? If yes, could you please confirm what type of authentication is being used in your dataset linked service connection? Are you using any keyvault for secrets?
Is this a new dataset or an existing old dataset? If it is an existing old dataset, then could you also give a try creating a new dataset and see if how it goes?
Do let us know based on the above tests.
Thank you
-
KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator
2021-11-29T18:23:36.72+00:00 Hi @Anonymous ,
We still have not heard back from you. Just wanted to check if you are still facing the issue or need assistance on this? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
-
![](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(131.20000000000002, 44%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Stuart 16 Reputation points2022-02-18T14:23:45.113+00:00 II'm experiencing a similar issue. Trying to use a file in Blob Storage as a source. I am able to preview the data and am using Managed Identity to link to the Storage Account. It's a new dataset.
Any ideas? -
Stuart 16 Reputation points
2022-02-18T14:24:36.817+00:00 I'm experiencing a similar issue. Trying to use a file in Blob Storage as a source. I am able to preview the data and am using Managed Identity to link to the Storage Account. It's a new dataset.
Any ideas? -
Niklas Letz 6 Reputation points2022-02-22T09:26:26.11+00:00 I also have the same problem with a Blob Storage. I'm also able to preview the data, using Access Key for auth (not in KeyVault) and it's a new dataset.
This is how the (default) code looks like:let
AdfDoc = AzureStorage.BlobContents("https://StorageAccountName.blob.core.windows.net/ContainerName/FileName.csv"),
Csv = Csv.Document(AdfDoc, [Delimiter = ",", Encoding = TextEncoding.Utf8, QuoteStyle = QuoteStyle.Csv]),
PromotedHeaders = Table.PromoteHeaders(Csv, [PromoteAllScalars = true])
in
PromotedHeadersCould you please help me?
-
John Palmer 66 Reputation points2022-03-02T22:14:04.41+00:00 I asked a new question since the replies here haven't received any responses:
-
John Palmer 66 Reputation points
2022-03-02T22:14:15.373+00:00 I asked a new question since the replies here haven't received any responses:
-
John Palmer 66 Reputation points
2022-03-02T22:14:27.727+00:00 I asked a new question since the replies here haven't received any responses:
Sign in to comment
Sign in to answer