The DOM parser failed to load and parse the stream. URL:'' Reason: 'Incorrect CDATA section syntax.

[Anonymous]

Hi All,

I am getting the issue below and I don't know how to fix it:

Failed to save modifications to the server. Error returned: 'The DOM parser failed to load and parse the stream. URL:'' Reason: 'Incorrect CDATA section syntax. ' Source:''. File position: 0. Line: 4. The current operation was cancelled because another operation in the transaction failed. '. Power Bi how to solve

Could anybody has the solution to share, please?

Thanks

[Anonymous]

I am experiencing the same kind of error. 

I have 2 power bi datsets both refresh fine without error independently. When I try to join both power bI datasets and refresh thats also fine but when I add a calculated table which returns a intersect of two calculated tables thats returning the below error

Failed to save modifications to the server. Error returned: 'The DOM parser failed to load and parse the stream. URL:'' Reason: 'Incorrect CDATA section syntax. ' Source:''. File position: 0. Line: 3. The current operation was cancelled because another operation in the transaction failed. A connection could not be made to the data source with the Name of '{"protocol":"analysis-services","address":{"server":"powerbi://api.powerbi.com/v1.0/myorg/Power%20BI%20Certified%20Datasets","database":"?###name####"},"authentication":null,"query":null}'. The following system error occurred: '.

[Anonymous]

Hi Amitchandak,

Thank you very much for your reply. I get no issue when a refresh the tables separately. Only when I refresh the Report Dataset. 🤔

[Anonymous]

I meant I'm refreshing one by one. I get no this error when I'm refreshing other dataset tables, only in one specific one (which is a report with all of the tables that I'm refreshing and went okay)

[amitchandak]

@Anonymous , If you refreshing more than one table on the desktop, then refresh one by one and find the error in the table which fails first and share that