Error thrown when using query against managed entities.

ITLec / PowerQueryBuilder

13 stars 5 forks source link

Error thrown when using query against managed entities. #25

Open mscottsewell opened 5 years ago

mscottsewell commented 5 years ago

I'm hitting two challenges - and I'm not sure which portion is the 'root' of the other two challenge.

1) There are some custom (managed) entities not showing up in the list of entities in the Query Builder - but those entities are available in the FetchXML Builder.

2) If I build the query in FetchXML builder (works fine) and then return the view to PowerBI Query Builder, I get this error.

mscottsewell commented 5 years ago

Here are the entities that start with "msfp_" in FetchXML:

Here is the only entity that starts with "msfp_" visible in the PowerBI Query Builder:

ITLec commented 5 years ago

Thanks a lot for your comments, We already implement this feature. -Errors when generating queries based on custom FetchXML with entities not available in Advanced Find has been fixed. It is now possible to pass any query generated in the FetchXML Builder to the Power Query Builder, either manually or using the integration.