Forum Discussion

Prodingero's avatar
Prodingero
Helper I
3 years ago

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.
After that it apeears the error-message below:

 

- Authentication fails

Need Help

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi Prodingero ,

     

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

    Reduce the auth level here:

     

    Pete

    • Prodingero's avatar
      Prodingero
      Helper I
      3 years ago

      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