I am trying to get data from CRM via the REST API. I am able to authenticate and retrieve data from CRM, but the data I receive looks different from the same data collected in Power BI.
I am trying to retrieve data from oppertunityproducts. When running the query in Power BI I get this:
But when running the query in cURL I only get these attributes:
@odata.etag
baseamount
baseamount_base
ca_amountexclcloudlicensingcalc
ca_amountexclcloudlicensingcalc_base
ca_cm
ca_cm_base
ca_costamount
ca_costamount_base
ca_costperunit
ca_costperunit_base
ca_discountpercentage
ca_enddate
ca_extendedcostamount
ca_extendedcostamount_base
ca_forecastproduct
ca_months
ca_oppidproductidcalc
ca_opportunityidcalc
ca_productid
ca_startdate
ca_targetamount
ca_targetamount_base
createdon
description
entityimage
entityimageid
entityimage_timestamp
entityimage_url
exchangerate
extendedamount
extendedamount_base
importsequencenumber
ispriceoverridden
isproductoverridden
lineitemnumber
manualdiscountamount
manualdiscountamount_base
modifiedon
msdyn_billingmethod
msdyn_budgetamount
msdyn_budgetamount_base
msdyn_costamount
msdyn_costamount_base
msdyn_costpriceperunit
msdyn_costpriceperunit_base
msdyn_duration
msdyn_enddate
msdyn_linetype
msdyn_startdate
opportunityproductid
opportunityproductname
opportunitystatecode
overriddencreatedon
parentbundleid
priceperunit
priceperunit_base
pricingerrorcode
productassociationid
productdescription
productname
producttypecode
propertyconfigurationstatus
quantity
sequencenumber
skippricecalculation
tax
tax_base
timezoneruleversionnumber
utcconversiontimezonecode
versionnumber
volumediscountamount
volumediscountamount_base
_ca_productgroupid_value
_createdby_value
_createdonbehalfby_value
_modifiedby_value
_modifiedonbehalfby_value
_msdyn_pricelist_value
_msdyn_project_value
_msdyn_serviceaccount_value
_opportunityid_value
_ownerid_value
_owningbusinessunit_value
_owningteam_value
_owninguser_value
_parentbundleidref_value
_productid_value
_transactioncurrencyid_value
_uomid_value
I am missing the interesting ones with the reference data.
When running fiddler I can see, that Power BI does some batch lookups, when the tables and lists are expanded.
Is there an easy way to get the exact same query that Power BI makes running via cURL?
