Forum Discussion

Amratya's avatar
Amratya
Advocate I
8 years ago
Solved

DataSource.Error Web.Contents failed to get data from (500): Internal Server Error

Hi Everyone,   When I'm trying to refresh my data I got this error An error occurred in the ‘Sample File’ query. DataSource.Error: Web.Contents failed to get contents from 'https://xxxx-my.sha...
  • Amratya's avatar
    8 years ago

    It seems there was a problem in the data source in addition to this ApiVersion thing.

    1. Remove [ApiVersion = 15]
    2. Adding the datasource [sharePoint folder link] through the advanced query editor
    3. Filter files and get the desired ones

    I recognized there is additional row under my filtered files [Error - Error] and it is not filtered out. So, below steps to eliminate this error record from ruining my data, and I had so many files in different dashboards. So, I went through these possibilities here

    • Click on Remove Rows, then Remove Error.
    • If it didn't work, Click Remove Rows and then Remove the last rowfrom below.
    • If it didn't work, Click Keep Rows and then keep numbbers of rows from above.

    and then folow any other steps you want to apply on your data. and it worked.