AI & Analytics
Power Query in Power BI is where the magic happens. This session will cover what Power BI report builders need to know about Power Query when using it for getting data out of Dynamics 365. Power Query is used to retrieve and transform the Dynamics 365 data, from its database schema in the Common Data Service, to the semantic Power BI data model that can be utilized for report building and natural language querying. This session will cover the main ways of extracting data from D365, including OData, CDS connector, and using the Power Query Builder in the XrmToolBox. Each method has its own pros and cons and using the correct method at the right time can save you a lot of time. The Power Query Builder tool can save users hours of data modeling time by automaticallt incl. option set labels and names on lookup fields. Ulrik, CRM Chart Guy will cover all the tips and tricks on how to best use this tool.