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?
6 Comments
- fbcideas_migusrNew MemberI agree, not least because this would let us run FetchXml aggregate queries on the CRM-side
- erkki_jantunen2New MemberI agree
- SmallCityGuyRegular VisitorI 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.
- m_khan3New MemberI 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.
- m_shariffNew MemberAgreed. FetchXML features would enhance PowerBI capabilities and steam up the evolution of constructing dashboards and reports from CRM online.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
New Advanced Editor hides query name and locks editor window
Classic Power Query 'Advanced editor' opens as a separate movable, resizable window with the query name as its title. One could drag and keep the main editor visible : queries pane, applied steps, d...Mardurolla7 hours agoRegular VisitorNew8Views0likes0CommentsGet Secret from Azure Key Vault using Fabric Workspace Identity
Users can access key vault secrets using notebookutils.credentials.getSecret. This is based purely on the user's access (or object owner's access, if the notebook is being run in a pipeline). In larg...sean_cochran7 hours agoResolver INew3.1KViews14likes3CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...lamogiro8 hours agoNew MemberNew7Views0likes0CommentsPaginated Reports with PowerQuery - Cloud connections for Snowflake connector
Current situation: Power BI report builder used to build a report using Power Query dataset. Report builder picked the right cloud snowflake DB connection (created in Power BI service portal - app...jarjis_nbcu8 hours agoNew MemberNew2Views0likes0CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...Mardurolla8 hours agoRegular VisitorNew8Views0likes0Comments