I’ve been building Power Automate flows that take rows from Excel and create
sales orders and sales order lines in Dataverse. It’s pretty standard, but I
keep needing to reference related records (like the customer or a delivery
warehouse or somet...
If you’re using Power Automate and Business Central, you might have played with
environment variables. For Power Automate flows that are built inside a
solution, environment variables can be created to represent an environment or
company in Busine...
For years, business intelligence has been synonymous with dashboards. Rows of
charts, filters, and KPIs that require interpretation and follow-up. Tools like
Power BI and Tableau helped us go from raw data to insights, but the final step
has alway...
Here’s another one that popped up from someone looking for Power BI support at
Tapestries Group. I’ve also run into this at Dynamics User Group a number of
times, so here’s a couple of approaches The problem – a delimited column with
multiple valu...
Overview Had someone reach out to me Tapestries Group asking how to use Azure
the paths feature of Azure Maps. Their specific request was to have a map that
had both paths and points layered on top of each other. How to build the data
This was pre...
I have two monitors, but I don’t like moving my head around. Especially when I’m
on a Teams call – I like to have OneNote available to take notes, but don’t like
not being able to look at someone and see them when I’m taking notes. Switching
back ...
I wrote a post about how to use Power Automate and Power BI together. It’s
pretty cool, but I also want to be able to add some free text to the Power
Automate directly from Power BI. One approach would be to use Teams and send
myself a responsive ...
This post will be relevant to you are using Power BI to calculate utilization
like I referenced in a past post. This particular report has a separate date
table, and I like to display the data by putting the start of month value in the
columns of ...