topic Re: Web.Contents failed to get contents in Report Server

Web.Contents failed to get contents

Anonymous — Mon, 05 Sep 2022 09:24:27 GMT

Hi, could you help me, please?

Until today, my report was updated automatically and without problems. Update failed today with this error:

Data source error: DataSource.Error: <ccon>Web.Contents failed to get contents from 'https://iweof.sharepoint.com/teams/o365g_rucscbsdatabase_retruc01/_api/web/getfilebyserverrelativeurl('/teams/o365g_rucscbsdatabase_retruc01/Shared%20Documents/Chats/%D0%94%D0%BB%D1%8F%20%D0%B3%D0%BB%D0%BE%D0%B1%D0%B0%D0%BB%D1%8C%D0%BD%D0%BE%D0%B9%20%D1%81%D1%82%D0%B0%D1%82%D0%B8%D1%81%D1%82%D0%B8%D0%BA%D0%B8/%D0%94%D0%B5%D1%82%D0%B0%D0%BB%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F%20%D0%BE%D0%B1%D1%80%D0%B0%D1%89%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%BF%D0%BE%20%D0%BA%D0%B0%D0%BD%D0%B0%D0%BB%D0%B0%D0%BC%20%D0%BA%D0%BE%D0%BC%D0%BC%D1%83%D0%BD%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8%20(05.10.20%20-%2005.10.20).csv')/$value' (429): . DataSourceKind = SharePoint. DataSourcePath = https://iweof.sharepoint.com/teams/o365g_rucscbsdatabase_retruc01. Url = https://iweof.sharepoint.com/teams/o365g_rucscbsdatabase_retruc01/_api/web/getfilebyserverrelativeurl('/teams/o365g_rucscbsdatabase_retruc01/Shared%20Documents/Chats/%D0%94%D0%BB%D1%8F%20%D0%B3%D0%BB%D0%BE%D0%B1%D0%B0%D0%BB%D1%8C%D0%BD%D0%BE%D0%B9%20%D1%81%D1%82%D0%B0%D1%82%D0%B8%D1%81%D1%82%D0%B8%D0%BA%D0%B8/%D0%94%D0%B5%D1%82%D0%B0%D0%BB%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F%20%D0%BE%D0%B1%D1%80%D0%B0%D1%89%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%BF%D0%BE%20%D0%BA%D0%B0%D0%BD%D0%B0%D0%BB%D0%B0%D0%BC%20%D0%BA%D0%BE%D0%BC%D0%BC%D1%83%D0%BD%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8%20(05.10.20%20-%2005.10.20).csv')/$value. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Chats total.
Cluster URI: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID: f7db6cb0-1cbc-40c5-8ab1-1eabbc9101a6
Request ID: 4afba23c-8c82-fa3f-8832-23e1059b559d
Time: 2022-09-05 06:24:07Z

The update file is stored in SharePoint. Refresh on demand also fails. What could be the problem?

Re: Web.Contents failed to get contents

Jessfv92 — Mon, 05 Sep 2022 13:01:22 GMT

I had the same problem this morning. I just refreshed on demand twice and it finally worked. Hope it gets solved too!

Re: Web.Contents failed to get contents

NguyenTan — Tue, 06 Sep 2022 03:21:39 GMT

I have the same issue. It happen in recent days. Some time I can refresh successfull, some time fail.

Re: Web.Contents failed to get contents

NguyenTan — Tue, 06 Sep 2022 03:27:50 GMT

And this issue only happen with the report that have the link to excel file in OneDriver (which worked smoothy before, automatic updated and I dont make any change to that)

Re: Web.Contents failed to get contents

rasika_gulwelka — Tue, 06 Sep 2022 06:49:01 GMT

Hello,

We are also getting same error since 08-30-2022. If refreshed manually, it worked once. Later on its failing for both manual & scheduled refresh with same error.

Any help/suggestion arround this? Is this related to another internal issue submitted for exception raised by the IDbCommand interface- ICM 280081207
Solved: The table has no visible columns and cannot be que... - Microsoft Power BI Community

Thanks.

Re: Web.Contents failed to get contents

Anonymous — Tue, 06 Sep 2022 07:03:12 GMT

Hi Anonymous ,

We analyzed logs and were able to locate the root cause of the issue. and we found that the issue may from SharePoint because of 429 error which appears as throttling issue.
We sugguest you to create a ticket with SharePoint team to look into this matter.

Best Regards,
Community Support Team _ Caitlyn

Re: Web.Contents failed to get contents

Anonymous — Tue, 06 Sep 2022 10:13:46 GMT

Hi Anonymous,
Could you tell me how to contact the SharePoint team, please?