Forum Discussion

Stan_Ogden's avatar
Stan_Ogden
New Member
9 years ago

Error importing data for Dynamics 365 sales content pack

Hi I have set up a new CRM and am working on the sandbox with the standard sample data I have logged into the Power BI service and clicked get Data then browsed to a content pack called "Sales Anal...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Stan_Ogden,

 

While this post hits my exact issue right on the head, I am sorry but I'm still not clear exactly what your colleague did to correct the issue with the Account entity. It would be incredibly helpful if we knew what was copied from what table to correct this. Thank you.

 

contisma's avatar
contisma
New Member
9 years ago

If you goto the query editor, right click on the Accounts query and select advanced editor.

In here you will see:

 

let
	Source = OData.Feed(CRMServiceUrl, null, [Concurrent = true, ODataVersion = 4, Query=[fetchXml="%3Cf......

The Query= section is what is now failing since the update.

 

Remove the 

, Query=[fetchxml=.....]

so you end up with

let
	Source = OData.Feed(CRMServiceUrl, null, [Concurrent = true, ODataVersion = 4]),
        accounts_table = ......

and this should fix the error.

A key piece of the query that is lost is the fetchxml was filtering to only accounts that had an opportunity that was modified in the last 365 days.

 

If you have the time to identify what is wrong with the fetch xml, I would be intrigued to know what should be in the "query" section.