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

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.