Forum Discussion

JGauthier's avatar
JGauthier
New Member
4 years ago

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

Hi everyone,   I have been using Power Query to import Data from Excel files located on an On-premise SharePoint site for a while. For an unknown reason, none of my reports are working now. I keep...
Need Help
JGauthier's avatar
JGauthier
New Member
4 years ago

This is exactly what i am doing. I use Windows Credentials and it doesn't work, whereas for my other test with the source on SharePoint Online, it is with Organizational Account.

 

Is there a way to see what's that HTML web page message is telling ?

 

thank you.

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi JGauthier ,

Whether you can tried to use Power BI Desktop to connect to the web site to check it has the same issue or not, you can use the Web connector which is built in Power BI Desktop to connect it directly.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JGauthier's avatar
    JGauthier
    New Member
    4 years ago

    Hi,

    I've tried Power Desktop (File/Excel then my SharePoint URL) and it works.

    Does that help to figure out why the connector within Excel doesn't work ? That's the one I need.

    thanks!