Forum Discussion

Carreira's avatar
Carreira
New Member
2 years ago
Solved

DataSource.Error: The downloaded data is HTML, which isn't the expected type - Personal One Drive

Hi everyone,   8 months ago I have created a report in Power BI and I used as databases some excel files I have in my personal OneDrive, to do that I had to go to OneDrive and embed the Excel file,...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Carreira 

    The error message you’re seeing, “The downloaded data is HTML, which isn’t the expected type,” suggests that Power BI is receiving an HTML page instead of the expected Excel file. 

    Navigate to your OneDrive. Select the ellipses (...) to open the More menu, then select Details. In the More details pane that appears, select the copy icon next to Path. Ensure the link ends in .xlsx (for Excel files). Please refer to this link for more: Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn


     

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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

After thinking about the problem "The downloaded data is HTML, which is not the expected type. etc etc", I have found that it does not work for OneDrive Personal but it does work for OneDrive Business. I checked it out.

Now the question is, why?