Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bhawnaA
Frequent Visitor

Dataverse Data (Import ) Load Issue

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 )

bhawnaA_1-1684725692228.png

 

bhawnaA_0-1684725575172.png

Error I get while importing Contact from Dataverse :

bhawnaA_2-1684726354603.png

 



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 

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

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:

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors