Forum Discussion
we couldn't authenticate with the credentials
Super UserHey 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
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.