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

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.