Share via

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

John Palmer 66 Reputation points
2022-03-02T22:07:35.563+00:00

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 Lake Storage
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.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Community Center | Not monitored

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Somasekhar Kandiboti 6 Reputation points Microsoft Employee
    2022-03-03T11:20:17.033+00:00

    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.

    1 person found this answer helpful.
  2. John Palmer 66 Reputation points
    2022-03-04T18:48:14.913+00:00

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

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.