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.
891 questions
Trying to use power query on ADF error: "We could not evaluate this query due to invalid or missing credentials"
asked 2021-11-18T12:46:54.15+00:00
Calrin Curtis
96
Reputation points
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
{count} votes
-
KranthiPakala-MSFT 32,896 Reputation points Microsoft Employee
2021-11-19T15:50:29.047+00:00 Hi @Calrin Curtis ,
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 32,896 Reputation points Microsoft Employee
2021-11-29T18:23:36.72+00:00 Hi @Calrin Curtis ,
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.
-
Stuart 16 Reputation points
2022-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 61 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 61 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 61 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