question

johndpalm avatar image
1 Vote"
johndpalm asked AnnuKumari-MSFT commented

Azure Data Factory Power Query error: "We could not evaluate this query due to invalid or missing credentials"

I'm trying to add a Power Query resource to Azure Data Factory v2 (ADF). The dataset that I'm consuming is Parquet. I can successfully preview the data from within the dataset. As well, I can open and read the .parquet file from it's location in Azure Data Lake Storage Gen2 (ADLS) through Azure Storage Explorer.

When I create a Power Query and add the dataset, the Power Query displays this error: "We could not evaluate this query due to invalid or missing credentials."

179433-image.png

The linked service from ADF to ADLS is authenticated through an account key in Azure Key Vault. The data copy action uses this linked service to write to ADLS sink, go this is confirmed to be good. I also confirmed the URL within the Power Query query is the correct ADLS endpoint for the resource.

How do I resolve the "We could not evaluate this query due to invalid or missing credentials" error?

azure-data-factorypower-query-not-supportedazure-data-lake-storage
image.png (56.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @johndpalm ,
Please do consider accepting answer by clicking on Accept answer button as accepted answers help community as well.

0 Votes 0 ·
SomasekharKandiboti-9835 avatar image
1 Vote"
SomasekharKandiboti-9835 answered AnnuKumari-MSFT commented

This could happen for several reasons - using parameterized linked service which is not supported in Power Query (Or) using an unsupported authentication type (Or) some system issue.

Please share the factory\linked service names and the timestamp of the issue to further analyze it.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


I removed and re-added the Power Query and it's working now. I'm not sure what, if anything, I did differently the second time.

2 Votes 2 ·

Hi @johndpalm ,
Glad to know that the issue has been resolved. Please do consider accepting answer by clicking on Accept answer button as accepted answers help community as well.

0 Votes 0 ·

Hi @johndpalm ,
Please do consider accepting answer by clicking on Accept answer button as accepted answers help community as well.

0 Votes 0 ·
johndpalm avatar image
1 Vote"
johndpalm answered

I removed and re-added the Power Query and it's working now.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.