Dataverse Data (Import ) Load Issue

[bhawnaA]

Hi Guys ,

WHile i try to get data from Dataverse -- Select a table Lets say Activity Party , Along with the main column , a lot of merged/Linked tables are imported by default which i manually delete in Power Query .

Is there any way this can be avoided ? 
As because of this data size increases and some tables ( per say Contacts is not able to load )

Error I get while importing Contact from Dataverse :

DataSource.Error: Microsoft SQL: An error occurred while sending the request.
RequestId: TDS;76347d69-9e7b-4921-8f46-b0dc6f186a5a;5
Time: 2023-05-22T03:29:33.3437609Z
Details:
DataSourceKind=CommonDataService
DataSourcePath=manawanui.crm6.dynamics.com
Message=An error occurred while sending the request.


RequestId: TDS;76347d69-9e7b-4921-8f46-b0dc6f186a5a;5
Time: 2023-05-22T03:29:33.3437609Z
ErrorCode=-2146232060
Number=40000
Class=16


All Help is appreciated 
@Ashish_Mathur  , @amitchandak  , @BA_Pete 

[Syndicate_Admin]

I was getting the same error while querying dataverse tables. In my case the columns regardingobjectidname and regardingobjectidyominame weren't being found. I've just oppened the advanced editor and written in the next row the column remove function and it worked!

The same error:

What i've done to get rid of it: