I have built a data model with the data in SharePoint. If I refresh in PBI desktop, it refreshes without a problem. However, when I try to refresh in the service I get the following error message…
Data source error: Expression.Error: We cannot convert the value “[Binary]” to type Binary… . The exception was raised by the IDbCommand interface. Table: GL Detail.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 9a075988-69b1-4d0e-abe6-593fcdf0bf3d
Request ID: 3ca5fa34-9413-417c-b561-c1db66aa720e
Time: 2022-08-05 02:43:29Z
When I was searching on the web, it mentioned something about privacy settings. I thought I have the privacy settings as Organizational with Microsoft login.