Forum Discussion
Facing an issue while connecting with Dataverse
I'm getting the Opportunities table from Dataverse but getting the below error. DataSource.Error: Microsoft SQL: Invalid column name 'accountid'. Invalid column name 'accountidname'. Invalid co...
Experienced the same problem, possibly since activating 2022 release wave 2.
Data seemed to load fine in Power BI Desktop but wouldn't refresh in the service.
Managed to solve it by identifying several 'Removed Columns' steps in 'Transform Data' queries and removing the problem field(s) - it means they now show in the data, but eliminates the data refresh problem.