Connecting PowerBI with an excel file in OneDrive

[marzanc01]

I have been trying to connect an excel to powerBI through the web connector. Everytime I do so and try to connect it with an organizational account, it prompts "We were unable to connect because this credential type isnt supported for this resource. Please choose another credential type". And this is being displayed for every level. What do I do?

[Akash_Varuna · Accepted solution]

Hi @marzanc01 Ensure you are using the OneDrive for Business link (not the shared or public link). Get the link by selecting "Open in Excel" in OneDrive, then copy the URL from the browser.

Use the SharePoint Foder connector in Power BI instead of the Web connector. Ensure the correct file link is used and that your organizational account has access.

[v-hashadapu]

Hi @marzanc01 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[pankajnamekar25 · Accepted solution]

Hello @marzanc01 

you can explore 

Power BI Desktop OneDrive and SharePoint integration - Power BI | Microsoft Learn

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-hashadapu]

Hi @marzanc01 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @marzanc01 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[Akash_Varuna · Accepted solution]

Hi @marzanc01 Ensure you are using the OneDrive for Business link (not the shared or public link). Get the link by selecting "Open in Excel" in OneDrive, then copy the URL from the browser.

Use the SharePoint Foder connector in Power BI instead of the Web connector. Ensure the correct file link is used and that your organizational account has access.