Forum Discussion
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.
- Remove [ApiVersion = 15]
- Adding the datasource [sharePoint folder link] through the advanced query editor
- 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.
It seems there was a problem in the data source in addition to this ApiVersion thing.
- Remove [ApiVersion = 15]
- Adding the datasource [sharePoint folder link] through the advanced query editor
- 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.
I had a similar erro, but the issue was in the filename. It has a % in the name. Make sure you don't use special symbols in the file path and filenames.