Power Query Text/CSV connector authentication fails
Note
On September 1, 2023, we merged and renamed Dynamics 365 Marketing and Dynamics 365 Customer Insights. Dynamics 365 Marketing is now called Dynamics 365 Customer Insights - Journeys. Dynamics 365 Customer Insights is now called Dynamics 365 Customer Insights - Data. For more information, see Dynamics 365 Customer Insights FAQs.
This article resolves the error "The credentials provided for the source are invalid" that occurs during the authentication of the Text/CSV editor in Microsoft Dynamics 365 Customer Insights - Data.
Symptoms
When editing a Power Query data source that uses the Text/CSV connector, if you need to reauthenticate, the error message "The credentials provided for the source are invalid" occurs. After you select Configure connection, the error message persists, and the authentication fails.
Resolution
Note
To perform the following steps, you should be the owner of the connection or have administrator permissions to access all existing connections.
To solve this issue, refresh the connections on the Power Query transformations page.
- Open the Power Query connection.
- On the transformations page, select Manage connections.
- Refresh all listed connections. You can find the refresh icon next to the connection name by editing a connection.
- Refresh the browser page.
- Save the data source.