Failed to update data source credentials / sharepoint online / status code 400
I have tried seaching for a solution to this problem but have not found any so far.
I have created a report in power bi desktop using a sharepoint online list and have published it to power bi. So far so good. When I click refresh on the dataset, it fails.
"Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."
When I try to update the credentials and set the to "Authentication method: Windows" and "Privacy level: Organisational" I get "Failed to update" with Status Code: 400