Skip to content

crm chart guy

By Ulrik B. Carlsson, dedicated to visualizing data with Dynamics 365 – by a non-developer

  • Home
  • About CRM Chart Guy
  • MS CRM Chart Editor and XML Overview
  • Power Query Builder
HomePosts tagged 'DirectQuery'

DirectQuery

DirectQuery CDS from Power BI

May 29, 2020November 25, 2020 Ulrik (CRM Chart Guy) Power BI CDS, DirectQuery, PowerBI

Last year I wrote a lengthy blog post comparing the three main methods of getting Dynamics 365, or Common Data Service data into Power BI for analysis. Now, at the most recent Microsoft Business Applications Summit, a new method was announced that I was finally able to try out. The method is using the new … Continue reading DirectQuery CDS from Power BI

36 Comments

Top Posts

  • Embed filtered Power BI reports on Dynamics 365 forms - again - the official way
  • Power Query Builder
  • MS CRM Chart Editor and XML Overview
  • Aggregate Total on top of Stacked Column Charts or Bar Charts in MS CRM 2011
  • Use FetchXML in Power BI with Dynamics 365 customer engagement
Follow @crmchartguy     feed-icon-14x14

Enter your email address to follow this blog and receive notifications of new posts by email.

All Posts

  • “Support” for the Unified Interface in the Advanced Chart Editor for the XrmToolBox
  • Create Record Links From Power BI to Unified Interface and Dynamics 365
  • Use Icons from Power Apps Unified Interface in Power BI
  • DirectQuery CDS from Power BI
  • Compare This Year to Last Year – Unified Interface edition
  • Comparing the three main ways to get Dynamics 365 data into Power BI
  • Power Query (M) Builder for the XrmToolBox (April 2019 update and fixes)
  • Embed filtered Power BI reports on Dynamics 365 forms – again – the official way
  • Embed Power BI Visuals in Dynamics 365 – with Secure Embed
  • Quickly get Dynamics 365 data in to Power BI for Q&A
  • Use Color Codes from Option Sets in both Dynamics 365 charts and Power BI
  • Power Query Builder update for XrmToolBox. Create links to Dynamics 365, and handle tables with no records retrieved
  • Power Query Builder updated – now supports FetchXML to get your Dynamics 365 Views into Power BI
  • Duplicate Detection Rules Chart in Dynamics 365
  • Use the FetchXML Builder to help create charts in Dynamics 365
  • Contextual Power BI Reports on Dynamics 365 forms
  • More User based Charts in Dynamics 365
  • Chart your Security Roles in Dynamics 365
  • Update: Custom Properties grouped in Advanced Chart Editor for the XrmToolBox
  • Use FetchXML in Power BI with Dynamics 365 customer engagement
  • Update: Add MarkerStyles and Nodes with the Advanced Chart Editor for the XrmToolBox
  • Updates to the Advanced Chart Editor for the XrmToolBox
  • Color options and create a custom color palette for the Chart Editor in the XrmToolBox
  • Edit Charts in the XrmToolBox for Dynamics 365
  • Record Specific Power BI Reports in Dynamics 365 (only one click away)
  • Prefilter data for Power BI with OData URLs
  • Setup the Data Export Service with a Power BI Solution Template
  • Power BI and mixed Team/User Ownership in Dynamics 365
  • Time to expand the scope of the CRM Chart Guy blog
  • Crowdsourcing the ultimate Sales Dashboard for Dynamics 365/CRM
  • Custom Date Formats in Charts in MS Dynamics CRM
  • Charts on Forms, or User/Account Specific Dashboards
  • Charting on Activity Parties in MS Dynamics CRM
  • Bubble Charts in Dynamics CRM
  • Funnel Charts Suck and You Shouldn’t Use Them
  • Compare This Year to Last Year with a Dynamics CRM chart
  • Annotations in MS CRM Charts
  • Add Key Figures on Opportunities to Sales Dashboards in MS Dynamics CRM
  • N:N Relationship Charts in MS Dynamics CRM
  • Add Percentage Labels to a 100% Stacked Bar chart in MS Dynamics CRM
  • Display only complete weeks or months in charts
  • Is your “Regarding” field on activities set correctly?
  • All things Pie Chart in Dynamics CRM
  • Multiple entities in one MS CRM chart
  • Create a Gantt Chart in MS CRM
  • Count Distinct or Unique items in MS CRM Charts
  • Design options for bar charts and Top X bar charts
  • Advanced Campaign Performance Chart in MS CRM
  • LabelFormat Cheat Sheet
  • Groupby Business Unit – even when not present (i.e. Activities/Opportunities)

Categories

  • Activities chart
  • Aggregate Total
  • Axis
  • BarChart
  • Bubble Chart
  • Campaign Chart
  • Chart XML
  • Charts on Forms
  • Colors in charts
  • Commentary
  • Count Distinct
  • CustomProperties
  • Data Export Service
  • Dataflows
  • Filter in chart XML
  • Format
  • Funnel Chart
  • Gantt Chart
  • Groupby
  • Guides
  • LabelFormat
  • Legend
  • Multi-entity charts
  • Multiple Series
  • N:N Relationships
  • Order charts
  • Percentage
  • Pie Chart
  • Power BI
  • Power Query Builder
  • Related Entities
  • Sales Charts
  • Sales Dashboard
  • Samples
  • ScaleBreak
  • Uncategorized
  • Unified Interface
  • Week Chart
  • XrmToolBox
Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • crm chart guy
    • Join 735 other followers
    • Already have a WordPress.com account? Log in now.
    • crm chart guy
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...