Author: jac_rod
-
How to make Power App and Power Automate work together?
Was working with Power Apps and the Microsoft Graph API, and it seemed easiest to put together a couple of flows to interact with it asynchronously. I wanted to both pull data down from the graph API and also update data. Regardless, I was building a little prototype app, and I got stuck on something.…
-
What is DAX and how does it relate to Dynamics 365?
DAX can mean lots of things. In the context of Power BI, DAX stands for “Data Analysis Expressions”. It’s a language used when creating calculations in Power BI – similar to Excel functions. In the context I want to discuss, though, DAX is shorthand for Dynamics AX. Microsoft Dynamics AX was the last name of…
-

How to find users in Azure B2C by email address
In this post I show how I troubleshoot issues with a PowerShell script to update user records in Azure AD B2C using ChatGPT and Claude.ai
-

Calculate utilization from Dynamics 365 with Power BI and ChatGPT
Do you want to know how to calculate utilization for your consulting company? Me too! Thankfully, I have Power BI and ChatGPT is around to help…
-

An easy approach to Dynamics 365 Business Central Go-Live
Want to learn how to migrate from a legacy ERP system to Business Central? Hopefully this helps.
-

How to easily consolidate companies in Business Central?
Yeah, you can. Using standard functionality, consolidations in Business Central is a breeze! Think you need a 3rd party solution to help? Think again.
-
Remote connecting via SSH. Permission denied (publickey).
Here’s one that I’ve struggled with probably 3-4 separate times in my life. As Josh Knox once said “my blog is just letters to my future self.” https://x.com/iamjoshknox/status/1800273741630599306 Anyway, this is related to WordPress and Linux. As you probably can tell, this site is based on WordPress and so are all the other blogs and…
-
How to integrate Mercury bank with Dynamics 365 Business Central
Next step on getting Dynamics 365 Business Central setup is using the Envestnet Yodlee connector for bank account automation. There’s a bunch of learn articles on how to set this up, but I wasn’t able to get it to work for all my bank accounts. I’ve included a link to the Learn article below. Set…
-
Discover the Bliss of Business Central with Extraordinary Personalization
I have a ton of experience in Finance and Operations, but the blocking and tackling of Dynamics 365 Business Central has been something I’ve been able to blissfully avoid for the entirety of my professional life. That’s changed. Here’s one of the first things I learned. Long story short, I’m trying to use the native…
-
“Condition not executed because of missing relationship: msdyn_projectteam”.
Hey, I’ve just started working in detail with Microsoft Dynamics 365 Project Operations, so forgive me if all this stuff I’ve been posting recently is known by everyone already. Regardless, I’m going to keep posting more things. This time, I was looking at the “Time entries for approval” view. I wanted to only see records…
