Forum Discussion
Import dataset from Microsoft Lists in Excel - Authentication fails
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. ...
Hi Prodingero ,
My guess is that you're trying to authenticate at too high a level.
Reduce the auth level here:
Pete
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