Import dataset from Microsoft Lists in Excel - Authentication fails

[Prodingero]

I try to import Dataset from Microsoft Lists in Excel with Power Query. Then it appears a user promt to select the authentication method.

If I select Microsoft Konto, I can sucessfull logon.
After that it apeears the error-message below:

- Authentication fails

[BA_Pete]

Hi @Prodingero ,

My guess is that you're trying to authenticate at too high a level.

Reduce the auth level here:

Pete

[Prodingero]

Hi @BA_Pete ,

now I start again, i get this new menue

and afterchoosing <OK> I get this error-message:

I think there is a difference between Sharepoint List  and Microsoft Lists.
A Method from Microsoft Lists to export data into Excel ist Exprt Dasa as Excel. In Excel after that you can only via direct query access the data in Microsoft Lists. A similar problm is, that I can in Microsoft Lists integrate Power BI, but it seems another version than the standard version, for example you cannot download the pbix file og the power bi reort genrated from Microsoft Lists.

Oliver