Forum Discussion

tjayapal's avatar
tjayapal
Regular Visitor
4 years ago

we couldn't authenticate with the credentials

To MS Account I have signed in and still facing the issue. Refer the attachment. I'm just trying to connect data in Excel which is in my OneDrive for Business. Even tried with Windows Credential too, but still facing the issue.

 

 

Need Help

5 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    4 years ago

    Hey tjayapal ,

     

    the link(type) you are using is not working from inside Power BI, this type of link is created with the intention to share access. Here you will some more information about this: Deciphering the SharePoint Online/OneDrive sharing links – One Minute Office Magic

    Next, you have to use Microsoft Account as the file is cloud-based, Windows Authentication is only used to connect to on-premises data sources.

     

    How to get the proper link is described here: How to simply connect Power BI to Excel file stored on SharePoint – Trainings, consultancy, tutorials (exceltown.com)
    Even if the article is talking about files stored in a SharePoint library it also works for files stored in onedrive. If you think this is complicated (not to say mad), you are right. But this is how it works.

    Hopefully, this helps to tackle your challenge.

     

    Regards,

    Tom

    • tjayapal's avatar
      tjayapal
      Regular Visitor
      4 years ago

      Hey, thank you for your message, for the past two months, I'm using the power BI with the same excel sheet and it was working fine. From last week this issue started to come and I was waiting for it to automatically solve, now trying to get help from here as the issue is not solved yet.

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Are you able to access it directly? Just to be sure that it is really not an authentication issue

    • tjayapal's avatar
      tjayapal
      Regular Visitor
      4 years ago

      Yes I can able to access the path both in browser and explorer and open the file.

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi tjayapal ,

     

    There are no recent related errors. You can try to connect to SharePoint in the power bi service to check if it works. Or update power bi desktop to the latest version.

    For more details you can refer this link.

    Power Query SharePoint folder connector - Power Query | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.