Hi all,
I have created a dataflow with tables that are created using an OData-api from one of our systems. The refresh is scheduled to take place every morning and has been working fine for almost a year. However, lately it seems to keeps throwing out my credentials/logging me out, which makes the refresh fail. It's not always the same error; today it said "Credentials not found for data source...". Earlier this week, it was "OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)".
I cannot edit credentials in the dataflow settings, those are greyed out. I have to manually open the dataflow (edit-mode) and enter the credentials again and then save & close, which takes a lot of time since its a relatively big dataflow. On top of that, I'm a parttime employee but the reports that are created with this dataflow are used daily and should be updated accordingly, which is currently not possible on days I'm not working.
Is there any way to solve this issue?
Edit: both Power BI and the system it's connected to use my Microsoft 365-credentials linked to my company-account.
