I want to publish a report created in PowerBI Desktop with a datasource pointing to a Sharepoint Online List.
I'm using the same credentials for Sharepoint Online (administrator) and PowerBI.
In PowerBI Desktop I am able to refresh.
I publish the file to PowerBI Online.
When I check the credentials of the DataSet created in PBI Online I see this message:
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Your data source can't be queried because the credentials are not provided. Please provide your credentials and try again.Hide details
I try to reenter credentials but the Authentication method is limited to Anonymous, Windows or Undefined. Choosing Undefined will result in the spinning wheel rolling endlessly.
How can I preserve the credentials from PowerBI Desktop to be able to use them in PBI Online?