Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I keep on getting this error message whenever i try to refresh a dataset from the service.
Expression.Error: We cannot convert the value <ccon>"[Binary]" to type Binary.. </ccon>. The exception was raised by the IDbCommand interface. Table: Corvet.
When i check for the error on desktop i don't find any type of error, and if i run the refresh from desktop it goes just right with no problem, the table doesn't contain many rows wich makes it even easier to look for the error but nothing to be found.
The dataset used to work fine for months until it no longer wants to refresh from the PBI Service.
anyone who encountered this problem and found the way ??
Solved! Go to Solution.
i got to go around the problem by making the transformations on a dataflow rather than in the dataset.
no problem in refreshing the dataset now, but still can't understand the source of the problem😕
i got to go around the problem by making the transformations on a dataflow rather than in the dataset.
no problem in refreshing the dataset now, but still can't understand the source of the problem😕
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!