Share via

[dataformat.error] We received a malformed web response from Web (Sharepoint)

Anonymous
2024-12-18T11:33:17+00:00

Hi,

I have a problem with connecting to files on Sharepoint. I have a difererent Excel files on Sharepoint connected with Power Querry. While opening file in Excel and refreshig connections I'm getting erroe on every qyerry. Please see uploaded image.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-12-18T13:52:10+00:00

    It could be authortication issue, you may try clear permission and resign in your account.

    Data>Get data>Data source settings>Clear perrmission, then resign in your account.

    Power query - "malformed web response" error - Microsoft Community

    Please understand that initial reply may not always immediately resolve the issue due to limited information. However, with your help and more detailed information, we can work together to find a solution.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments