I created a Power BI report that is connected to our Azure Tables. On my Power BI Desktop, the connection works fine. When I publish to the Power BI service, it will not connect to azure tables. Configure MMS_API_Statistics I have tried both Access Keys as well as changing the privacy level and I still get "Failed to update data source credentials: The credentials provided for the AzureTables source are invalid."
Not sure what I am doing wrong here.
There could be the following reasons for this issue:
When two-factor authentication is active for an account, it does not seem to work on Power BI cloud. Turning this off has fixed the issue.
Resetting the profile of the user we are using to connect from PowerBI
You can follow this MSFT Q&A answer by Oury Ba-MSFT to check if you missed any steps.
Reference - https://community.powerbi.com/t5/Issues/Failed-to-update-data-source-credentials/idi-p/135313
