Skip to main content

Power BI

Needs Votes

FetchXML Support for Power BI

Vote (50) Share
Arthur Nicholson's profile image

Arthur Nicholson on 22 Oct 2015 01:56:21

While oData is a good start, it's both very limited and has a performance impact compared to the native FetchXML provided by MS CRM. Could we enhance the current connector to support Fetch?

Comments (5)
Arthur Nicholson's profile image Profile Picture

Mansoor Khan on 05 Jul 2020 22:25:04

RE: FetchXML Support for Power BI

I agree as it will make CRM report developers life really easy.

Using Odata functionality is taking much time to load tables and its tedious to modal your data where we have used option fields.

Adding FetchXML features will definitely enhance PowerBI capabilities and speed up the process of creating dashboards and reports from CRM online.

Arthur Nicholson's profile image Profile Picture

Mohammed Shariff on 05 Jul 2020 22:25:04

RE: FetchXML Support for Power BI

Agreed.

FetchXML features would enhance PowerBI capabilities and steam up the evolution of constructing dashboards and reports from CRM online.

Arthur Nicholson's profile image Profile Picture

Colin Hogue on 05 Jul 2020 22:23:01

RE: FetchXML Support for Power BI

I agree as well. Been trying to filter the amount of data that PowerBI Desktop grabs from CRM to just be the Trailing 30 days (I know there are filters that I can use after I get all the data, just want to make it so that I don't HAVE to grab everything), and apart from the Unsupported Refresh of Programmatically created OData calls There really isn't much to do.

Arthur Nicholson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:12:50

RE: FetchXML Support for Power BI

I agree

Arthur Nicholson's profile image Profile Picture

Julian Elve on 05 Jul 2020 22:09:26

RE: FetchXML Support for Power BI

I agree, not least because this would let us run FetchXml aggregate queries on the CRM-side