Forum Discussion

Raghu04's avatar
Raghu04
Regular Visitor
1 year ago

Power BI Desktop

its possible or not - personel one drive account having excel file that i need to connect with organization account in power bi desktop? 

I tried to connect but I am getting error like

 

 "Unable to connect. We encountered an error while trying to connect. Details: 'The downloaded data is HTML, which isn't the expected type. The URL may be incorrect, or the necessary credentials may not have been provided to the server."

 

I tried with embed option also, embed code not given proper url link.

 

Any solution for this issue to resolve it. I need to connect via web connector option only in power BI desktop 

 

Need Help

3 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi Raghu04 

    By personal OneDrive, you mean an account that is not owned by an organization?  It is of course not possible to authenticate using your org account as they require different credentials and different method to connect.  For OneDrive personal, please follow the steps in this post https://community.fabric.microsoft.com/t5/Power-Query/PowerBI-support-for-OneDrive-Personal-as-data-source/td-p/129125


    Note that OneDrive for Business is owned by an organization and works similarly like SharePoint.

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    1 year ago

    what method are you using to connect when you select getdata?  can you share what you are doing?

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Hi Raghu04 

    It seems like you're trying to connect an Excel file from a personal OneDrive account to Power BI Desktop using your organizational account. This often leads to authentication conflicts between the personal and organizational accounts, resulting in the error you're seeing.

    Possible Solutions:

    1. Save Locally:

      • Download the Excel file to your local computer and connect to it from Power BI. This can help bypass the authentication issue, although it won't be automatically updated if changes are made in OneDrive.

    2. Move to Organizational Drive:

      • Move the file to your organization's OneDrive or SharePoint. This way, it will align with your organizational account and should solve the access problem.

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