Forum Discussion

tim81200's avatar
tim81200
New Member
1 year ago
Solved

Connecting a personal OneDrive to Power BI - HTML Data not expected

Hello everyone,   I am currently trying to import files that are stored on my personal OneDrive into Power BI. Previously, I did this through a SharePoint from my university, which worked without a...
  • v-sgandrathi's avatar
    1 year ago

    Hi tim81200,

    Thanks for reaching out to the Microsoft Fabric Community forum and Thank you MFelix and danextian for your response.

    Instead of using the URL from the Information section, you need to get the direct download link for the file. You can do this by right-clicking on the file in OneDrive and selecting Share then clicking on Copy link and make sure the link is set to "Anyone with the link can view" and then copy the link.
    Power BI does not support direct integration with OneDrive Personal like it does with OneDrive for Business. You need a Work or School account to connect OneDrive files directly. As a workaround, you can manually download the file, sync it locally, or try using a direct file download link.

     

    Please Accept as solution if this meets your needs and a Kudos would be appreciated.

     

    Regards,
    Sahasra.