Forum Discussion
The credentials provided for the AzureTables source are invalid.
- 1 year ago
Hi JolinTsai
Thank you for contacting the Microsoft Fabric Community Forum.
The error occurs because Power BI Service does not support using Azure Active Directory (Organizational Account) authentication for Azure Table Storage connections. While the connection works successfully in Power BI Desktop using your organizational credentials, these credentials are not automatically transferred to the Power BI Service after publishing. As a result, the dataset fails to refresh with the error: “The credentials provided for the Azure Tables source are invalid.” To fix this, go to the dataset settings in Power BI Service and update the data source credentials. Switch the authentication method from "Organizational Account" to either "Account Key" or "Shared Access Signature (SAS)", as these are supported. After entering and saving the correct credentials, your dataset should refresh successfully. Also, make sure the privacy level is set to “None” to match your Power BI Desktop settings. This will ensure a stable connection and proper authentication in Power BI Service.I hope this information is useful. If you need more assistance, feel free to reach out us . We will be happy to assist you.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
Okay...
I see the statement on the official document. This is so unsatisfying. What's the meaning to make credentials only works on Desktop? How come a product make an assumption that the users will not share their reports? And every reports that users made are one-time only, no more data updates?
Power Query Azure Table Storage connector - Power Query | Microsoft Learn
You've answered my question, though.