I check all my power query in Power Bi desktop, Zero error and refresh without problem. After published to Power Bi Service, Data Source error occured as below. [ValidateMarkupTags][ccon]Expression.Error: We cannot convert the value [ccon]"[Binary]"[/ccon] to type [ccon]Binary[/ccon].. [/ccon]. The exception was raised by the IDbCommand interface. Table: Daily Overdue.

So, I was finally able to solve this problem.The issue was with my data source credentials. Because my report used different data sources, it expected that each source would have the same credential as the other.To solve the issue, I went to the semantic models of my report and changed each credential to be the same as the other. For example, I used the OAuth2 authentication method and privacy level was set to Organizational for each of the data sources.This solved the problem for me. I hope it does for you as well.Best of luck.PS: If this solves the issue, please accept it as a solution to help others as well

No error Refresh in Power Bi Desktop, but have DataSource error in Power Bi Service

Forum Discussion

Related content

Refresh issue in desktop

Refresh fail due to DataSource error OData

Help with Odata Api call Refresh status returning Dynamic Datasources, which cannot be refreshed

Refresh all not refreshing datasource tables

PBI Desktop and SharePoint List Refresh Error