The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have set a scheduled refresh on Power BI but today found an error below but when I refreshed on Power BI desktop is no error.
Data source error: Expression.Error: <pii>We cannot convert the value "[Binary]" to type Binary.</pii>. . The exception was raised by the IDbCommand interface. Table: OB.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: f33510b4-c75a-43bc-baed-951122f429bf
Request ID: 10946e18-3a69-dd29-a8dd-494ab0e03ca0
Time: 2021-11-23 01:42:04Z
Solved! Go to Solution.
Hi, @Anonymous
The information you provided is too little for us to judge. Please add more information.
First, I suggest you check whether there is a binary data type in column in Power Query.
Second, you can check whether there is a problem with data source credentials, privacy level(public) in service.
Or you can try to delete all reports related and re-publish it to see if it has issue.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi,
Below might be the issue,
you might have connected a data source where a Column1 might be detected as a non binary so you would have manually changed it to Binary in the Query editor for your requirement. Later you might have replaced the data where the value in the Column1 might be the Binary and the power bi end also it might be automatically detected as Binary.
So this time it will throw this error as you have the Power query step to manually convert it to Binary again.
Hi, @Anonymous
The information you provided is too little for us to judge. Please add more information.
First, I suggest you check whether there is a binary data type in column in Power Query.
Second, you can check whether there is a problem with data source credentials, privacy level(public) in service.
Or you can try to delete all reports related and re-publish it to see if it has issue.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Thank you for consideration.
I try to revise the query again and that solved the problem.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
36 | |
31 | |
24 | |
21 | |
20 |
User | Count |
---|---|
61 | |
59 | |
53 | |
34 | |
33 |