Re: Invalid Credentials Error in Power-BI Service ...

stevenmcginnis · ‎05-08-2024

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.

amien · ‎08-08-2024

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

amien · ‎08-08-2024

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.

saumya_sri2311 · ‎05-14-2024

Hi,
Has there been any updates on this issue or fix?

Thanks.

v-nuoc-msft · ‎05-14-2024

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.

saumya_sri2311 · ‎05-15-2024

Unfortunately, still getting the same error on the service.

v-nuoc-msft · ‎05-15-2024

Hi @saumya_sri2311

I went to check this again.

Please try the following programs:

Do Power Query Online and Azure Storage have the same region? If yes, please refer to

Azure Data Lake Storage Gen2 - Power Query | Microsoft Learn

You need to use either an On-premises data gateway or a Virtual Network (VNet) data gateway to access Azure Storage from Power Query Online in the same region.

Do Power Query Online and Azure Storage have different regions? If yes, you need to add the IP addresses of the Power Query Online region to the Azure Storage Firewall in the 'Networking' settings.

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 · ‎05-15-2024

I've noticed on the documentation you've shared that it says the following relating to ADLS Gen2 connectors:

Limitations

Subfolder or file not supported in Power Query Online

Currently, in Power Query Online, the Azure Data Lake Storage Gen2 connector only supports paths with container, and not subfolder or file. For example, https://<accountname>.dfs.core.windows.net/<container> will work, while https://<accountname>.dfs.core.windows.net/<container>/<filename> or https://<accountname>.dfs.core.windows.net/<container>/<subfolder> will fail.

Does this mean that if I have multiple parquet files stored within a subfolder of this directory, that this might explain the refresh error? If so, is there a way around this?

v-nuoc-msft · ‎05-15-2024

Hi @stevenmcginnis

If feasible, consider reconfiguring the datastore by moving the necessary files to the root of the container.

For more complex scenarios or when working with large amounts of data across multiple subfolders, consider using Azure Data Factory.

Regards,

Nono Chen

v-nuoc-msft · ‎05-08-2024

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.

amien · ‎08-08-2024

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

stevenmcginnis · ‎05-09-2024

Hi @v-nuoc-msft,

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