Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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
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
In my case, I had 2 column headers that changed name (source is excel) - I had to remove lines above and then apply headers. So whenever the header text changed, I got this error.
Had to update the step with the error with the new/updated column names (which is a bit of a pain if the title has a line feeder in it).
already checked all and no error in power bi desktop but still have the same error msg in Power Bi Service
The error message you are encountering in the Power BI Service, specifically the "We cannot convert the value [Binary] to type Binary" error, indicates a problem with the data type conversion in your Power Query transformations. This error suggests that there is a data type mismatch between what Power Query expects and what it's encountering during the refresh in the Power BI Service.
To address this issue, follow these steps:
Review the Query in Power BI Desktop:
Check Data Types:
Check for External Data Sources:
Check for Privacy Levels:
Review Query Dependencies:
Test the Refresh Locally:
Data Source Credentials:
If you find this insightful, please provide a Kudo and accept this as a solution.
This ChatGPT response does not solve the problem as I am having the exact issue.
@FrankFan As you kudoed this reply, can you also accept it as a solution so that other users can find it more easily.
User | Count |
---|---|
24 | |
21 | |
11 | |
11 | |
10 |
User | Count |
---|---|
50 | |
31 | |
20 | |
18 | |
15 |