Invalid credentials when editing a dataflow in the PBI service, refreshing still works

[bjorn99_]

Earlier this week I needed to make some changes in a dataflow which connect through the Web connector to the REST API of ServiceNow (returns in JSON format). Unfortunately I’m still unable to make the needed changes. In the editing mode in the PBI service I’m getting the following error:

All the credentials are stored in a on-premisis Gateway. Weirdly the dataflow still refreshes successful manually, scheduled and through a process in Power Automate. I removed and readded the credentials in the gateway and the same problem still occurred. Connecting in PBI Desktop using the same credentials that are stored in the Gateway works as well. Editing dataflows connected to other data sources does not give me this problem.

[Anonymous]

Hello, I have solved the problem as follows:
1. I had several file type connections, I have disabled them from loading.
2. I created a folder type connection in the gateway.
3. I used this connection in the dataflow, and the problem was solved.
4. it seems that now you can only use one data source from the gateway in the same dataflow. being of file type, if they are in the same folder, it gives credentials error, at least that is my opinion.
greetings

Translated with www.DeepL.com/Translator (free version)

[JonnyB]

This one refers to a bug (317350811) logged by Msft:  https://community.powerbi.com/t5/Service/Adding-second-excel-file-in-a-dataflow-gives-error-Invalid/...

Suspect there's similar issues all related. Let's hope the Microsoft guys are connecting the dots on these and can fix it soon.