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.