Forum Discussion
Error importing data for Dynamics 365 sales content pack
Anonymous
Hi Lydia
My error is when using Power BI Desktop (with May update) with the Sales Manager.pbix content pack.
Dynamics 365 online Version 1612 (8.2.1.207).
Fails on 'Accounts' query with:
DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Invalid XML.)
Do you know if there is an updated content pack for this version of Dynamics 365 or if there is a correction available for the failing query?
In the end my learned colleague (who knows much more about this kind of thing than me) decided that the XML in the query for Accounts was bad. He fixed it.
I think MS have made a mistake and broken it when they have updated the pbix file.
I've worked around it by removing the fetchxml from my query. We don't have that many account records in the database and don't have a requirement to limit the number of account records returned to only those with opportunities modified in last 365 days. I'd like to know if I can use fetchxml in other queries though.
Did your colleague take the same approach, or were did they amend the fetchxml? If they fixed the fetch, would you be able to share the xml?
Also interested in the solution of changing the fetchmxl file.
Hi all apologies for the late response
Also apologies for my non techie answer
he went into the advanced editor on another table and copied something and pasted it into the advanced editor window of the account replacing what was already there.
hope that helps in some way