When starting with Power Bi Desktop in conjunction with Dynamics 365 Customer Engagement, you are presented with several routes to bring your data into the application. In this week’s blog post, I take a detailed look at four of these avenues, outlining the benefits of each one.
A few years ago on the blog, we saw how it was possible to utilise Fetch XML queries within Power BI. Things have moved on since then and, thanks to the awesome Dynamics community, there is now a way of getting around the issues highlighted in the original post...
Slight change of pace with this week's blog post, which will be a fairly condensed and self-indulgent affair - due to personal circumstances, I have been waylaid somewhat when it comes to producing content for the blog and I have also been unable to make any further progress with my new YouTube video series. Hoping [...]
I was recently showing a colleague how to use the rather excellent CRM REST Builder Managed Solution, in particular, its ability to generate code snippets for predefined query requests into Dynamics CRM/Dynamics 365 for Enterprise (CRM/D365E). During the demo, I noticed the following options under the Query Type drop-down with interest: I did some further [...]
I have had an opportunity recently to start getting to grips with the wonderful world of PowerBI. For those who have walked the tightrope between Excel and SQL Server Reporting Service (SSRS) Reports, PowerBI appears to be the tool with these individuals in mind. It enables you to leverage existing Excel knowledge (through PowerQuery or [...]
For those who have done a lot of work previously creating bespoke document templates within CRM, the only effective way in which you would traditionally do this within CRM was via a Report. For the uninitiated, reports are .rdl files that are created within CRM (for very basic reports) or via SQL Server Data Tools [...]
When working with CRM extensively across multiple environments, you do start to get into a fairly regular rhythm when it comes to completing key tasks again...and again...and again. One of these tasks is the process of rolling out a Solution update. To briefly summarise, this is where you export an updated version of your solution [...]
Working with Dynamics CRM can present some interesting challenges. What you tend to find is that you can pretty much say "Yes!" when it comes to doing most things you would expect from a CRM/database system, but there is a learning curve involved in figuring out the best approach to take. Often, as well, you may [...]