When trying to aceess XML data from Australian Burea of Statistics (ABS) through the http://stat.data.abs.gov.au/ service using the SDMX (XML) download service, I reguarly run into issues with the following error - Processing error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: Reference to undeclared entity 'nbsp'. Line 29, position 3 This is an intermittent error and occurs in different locations associated with downloadin the data. It reguarly pops up when using the service and setting automatic refresh. However, some refreshes work and others fail. The following is an example of refresh errors. There have been no changes to the file during this period. Refresh history ScheduledOneDrive Details Type Start End Status Failure message Show On demand 2/12/2017, 5:15:19 PM 2/12/2017, 5:15:25 PM Failed There was an error when processing the data in the dataset. Scheduled 2/12/2017, 9:07:10 AM 2/12/2017, 9:11:19 AM Completed Scheduled 2/12/2017, 8:37:15 AM 2/12/2017, 8:41:26 AM Completed Show On demand 2/11/2017, 5:59:31 PM 2/11/2017, 5:59:40 PM Failed There was an error when processing the data in the dataset. Show On demand 2/11/2017, 5:59:19 PM 2/11/2017, 5:59:28 PM Failed There was an error when processing the data in the dataset. Show On demand 2/11/2017, 5:59:09 PM 2/11/2017, 5:59:11 PM Failed There was an error when processing the data in the dataset. Show Scheduled 2/11/2017, 12:07:59 AM 2/11/2017, 12:09:13 AM Failed There was an error when processing the data in the dataset. This particular file can also refresh fine using PBI Desktop. The same error has also been occuring on a PBI Desktop file intermittently when looking at the Query Editor refresh but when you go out of Query Editor and refresh it works file. As the XML data is all web based I am not needed to refresh through a Gateway and I am able to use Conect Directly. I have contacted the ABS and they have reviewed their XML data and it does not have any mention of nbsp in the XML and does not have any errors in. The fact that this error is intermittent and that PBI Desktop can refresh the data makes me think that the issue is somthing to do with PBI rather than the XML data. All the errors that I am getting for this problem come up with the same message about nbsp'. Line 29, position 3. Can somone please look into this issue. Thank you for your assistance. I am happy an example PBI file that will demonstrate the issue if you can let me know where to send this to.
... View more