Forum Discussion
Error importing data for Dynamics 365 sales content pack
Stan_Ogden dimitrievski,
The issue has been reported internally to Power BI team, I will post back once I get any updates.
Currently, you can use Power BI Desktop as a workaround to connect to Dynamics 365.
Regards,
Lydia Zhang
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.
