I have added a new query to my existing dataflow. On saving the changes, PowerBI service completes validating the query and then get stuck on the screen which would take me back to the dataflow view screen.
My changes are not saved and next time I open the dataflow, it shows a message that the changes were not saved, do you want to use the cached version. I have tried clicking 'Yes' and 'No' on this message and tried completing my changes changes a few times but everytime it fails to save changes.
Here is the error details:
Activity ID: 2d79afab-c064-4ed1-9deb-2e69cc225da4 Request ID: 9a98843f-5c87-06f0-ab63-078d3ea993cb Correlation ID: 13d9ebf2-38d2-5e92-3b36-f0d9f656b124 Status code: 500 Time: Mon Nov 15 2021 19:49:25 GMT+0000 (Greenwich Mean Time) Service version: 13.0.17090.56 Client version: 2111.1.08596-train Cluster URI: https://wabi-us-north-central-f-primary-redirect.analysis.windows.net/
I wanted to add that the problem is only occuring when I am trying to setup a query which connects to a new data source. If I make a change to an existing query, the changes are saved successfully.