cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbilal079
New Member

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 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

mbilal079_0-1664877737733.png

 

How can i fix that?

Any help?

 

Thanks in advance.

 

@amitchandak  @Greg_Deckler  @parry2k 

 

5 REPLIES 5
tnguyen
Regular Visitor

I have the same issue and "Refresh Preview"  doesn't work.

Even I try to connect to make a new file access opportunity table via  Dataverse and have the same error message
Looking for a solution.

Thanks,

marine_adz
New Member

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.

Russ55
New Member

Hello @mbilal079, would be glad to hear if you manage to get this sorted. I'm having exactly the same error with the same column names on our dataverse opportunity table. I can't connect to them using PowerBI desktop or Excel. I can connect to it on our Dev environment but not on our UAT or Production environments. 

v-jingzhang
Community Support
Community Support

Hi @mbilal079 

 

Try opening Power Query Editor and clicking "Refresh Preview" in it. 

vjingzhang_0-1664939266510.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hi @v-jingzhang 

 

Thank you for your response.

 

I have refreshed it a couple of times but still having the same issue.

 

mbilal079_0-1664952109008.png

 

Thank You!.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.