Facing an issue while connecting with Dataverse
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.