Forum Discussion

dedelman_clng's avatar
dedelman_clng
Community Champion
9 years ago
Solved

Error connecting to SharePoint online

When trying to connect PowerBI Desktop to a SharePoint Online List, I can't even get to the page to put in my password because of an unknown error. My system admins are stumped as well.   I am usin...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    9 years ago

    Turns out our AD environment is using Kerberos authentication instead on NTFS, which the PowerBI to SharePoint online connector does not support.

     

    A ticket was opened with Microsoft and a workaround discovered (set our "Global Primary Authentication" policy for "Intranet" to "Forms Authentication" instead of "Windows Authentication")

     

    ADFS ManagerAuthentication PoliciesIntranet

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    The Microsoft rep helping my system admins is going to open a ticket with the PowerBI team for the bug.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi dedelman_clng,

 

From the image, the URL you are trying to connect is https://sts.cameronlng.com/adfs/ls/ , it seems that you are not connecting to the true SharePoint Online site.

 

Based on my test, when I use SharePoint Online List data source type, we can type the site which contains SharePoint list. For example, the list is below:

 

 

Then in desktop, type the site URL and sign in with valid account.

 

 

So in your scenario, please sign in the SharePoint Online via this URL: https://portal.microsoftonline.com/, and check if there is a SharePoint online list created in the site. Then follow the screenshots above to test if you can connect to it successfully.

 

Best Regards,
Qiuyun Yu

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    9 years ago

    Hi v-qiuyu-msft

     

    Before I get to the error screen this is what my connection looks like in PowerBI

     

     

     

     

     

     

     

     

     

     

     

     

     

    I click "Sign in"  and get this page:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    After I enter my email address, I get redirected to the "sts" page which throws the error.  In all use cases outside of PowerBI I can log into my corporate SPO without issue.  Are there cookies/cache/etc that are specific to PowerBI that might be corrupted or need updating/deletion?

    • dedelman_clng's avatar
      dedelman_clng
      Community Champion
      9 years ago

      Turns out our AD environment is using Kerberos authentication instead on NTFS, which the PowerBI to SharePoint online connector does not support.

       

      A ticket was opened with Microsoft and a workaround discovered (set our "Global Primary Authentication" policy for "Intranet" to "Forms Authentication" instead of "Windows Authentication")

       

      ADFS ManagerAuthentication PoliciesIntranet

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      The Microsoft rep helping my system admins is going to open a ticket with the PowerBI team for the bug.

      • goms's avatar
        goms
        Frequent Visitor
        9 years ago

        I am also encountering this error. But instead of redirecting me to "sts" page, I am redirected to https://fs.<company>.com/adfs/ls whats the difference?