Forum Discussion

stevenmcginnis's avatar
2 years ago

Invalid Credentials Error in Power-BI Service Despite Successful Connection in PBI Desktop. (ADLS)

I have a Power BI report that pulls data from Azure Data Lake Storage (ADLS). I can load and refresh the data smoothly using Power BI Desktop, but I encounter an issue when publishing the report to the Power BI web service. I'm unable to schedule a data refresh because the credentials are being flagged as invalid.

 

I've taken a few steps to troubleshoot the issue. I've confirmed that the credentials used in both Power BI Desktop and the web service are identical, I've ensured that the privacy level setting in the web service matches that of the Desktop.

I even tried deleting and reuploading the report in case the problem stemmed from a token caching issue, but unfortunately, that didn't resolve the issue.

 

The authentication method I'm using is OAuth. As I don't have admin rights for the ADLS data source, I can't generate a Shared Access Signature (SAS) token, and the process to obtain permissions can be time-consuming within my company, so I'd prefer to explore alternative solutions.

 

I'm wondering if anyone else has encountered a similar problem or knows what might be causing it and how to resolve it. I had a similar issue before which came down to the data being on-premise but that is not the case here.

 

The error reads: "

Failed to update data source credentials: The credentials provided for the AzureDataLakeStorage source are invalid. (Source at https://datasource.dfs.core.windows.net/path/to/folder)"

 

Any assistance would be greatly appreciated. 

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi stevenmcginnis 

     

    This issue has been confirmed as a known issue internally.

     

    Please be patient to wait for fixing.

     

    If there is any news, I will update it here.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • stevenmcginnis's avatar
      stevenmcginnis
      Helper I

      Hi Anonymous,

       

      Thanks for your response. I'm relieved to know its not a me problem! How long do you estimate it'll take to resolve? Do these type of issues typically take hours/days/weeks? I'm just trying to figure out my next steps.

       

      Thanks,

      Steven

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi stevenmcginnis 

         

        The incident has now been mitigated, but there is no exact time frame for a fix.

         

        If there is an update, I'll let you all know here.

         

        Regards,

        Nono Chen

    • amien's avatar
      amien
      Helper V

      This is not a Fabric capacity specific problem right? also with Premium capacity

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi saumya_sri2311 

       

      This issue has not been resolved at this time.

       

      Regards,

      Nono Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • I have the same problem. Invalid Credentials. No matter which Authentication kind i choose. Is it pretty safe to conclude that the storage account is reachable from PowerBI Services?

     

    v-nokumar Any website where we can track this incident? It's very inconvenient. 

  • But this is a topic from May and still not fixed?