Facing an issue while connecting with Dataverse

Muhammad Bilal 11 Reputation points
2022-10-04T10:22:25.1+00:00

I'm getting the Opportunities table from Dataverse in Power BI but getting the below error.

DataSource.Error: Microsoft SQL: Invalid column name 'accountid'.
Invalid column name 'accountidname'.
Invalid column name 'accountidyominame'.
Invalid column name 'contactid'.
Invalid column name 'contactidname'.
Invalid column name 'contactidyominame'.
Time: 2022-10-04T09:52:20.3765490Z
Details:
DataSourceKind=CommonDataService
DataSourcePath=seedspace1.crm6.dynamics.com
Message=Invalid column name 'accountid'.
Invalid column name 'accountidname'.
Invalid column name 'accountidyominame'.
Invalid column name 'contactid'.
Invalid column name 'contactidname'.
Invalid column name 'contactidyominame'.
Time: 2022-10-04T09:52:20.3765490Z
ErrorCode=-2146232060
Number=40000
Class=16

How can i fix that?

Any help?

Thanks in advance.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,482 questions
0 comments No comments
{count} votes