Category: Power BI
-
How-to use Azure maps paths and points in Power BI
Overview Had someone reach out to my 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 pretty straightforward to do. The data set for…
-
How to add comments to financial statements in Power BI
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 card with a request for comments,…
-
How to filter a Power BI report on YTD data
This post will be relevant to you if 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 a table. Sometimes, though, I run…
-
10 things I’ve done with the Power Platform
As you may have seen from some of my recent posts, Power Platform is a wide umbrella that covers a number of Microsoft Business Applications products. Here’s some things that are related to the Power Platform that I’ve done in the past: Personal Power BI reports Power BI is an awesome tool when building a…
-
Updating data in Dynamics 365 from Power BI
I had a list of companies in my Dynamics 365 Sales environment and a Power BI report with the last 12 months of sales data. I wanted to take that list of customers in Power BI and use it to update a flag in CRM that was called “active customers”. I started doing this by…
-
How is Power BI different from Microsoft Fabric?
Microsoft Power BI is a component inside Microsoft Fabric. I’ve been using Power BI for a long time. Since it came out, I think. I think it was some sort of Excel add-in at first and it’s since morphed into a pretty awesome reporting and analytics toolset offered at a somewhat reasonable price. I’ve even…
-
Not all my records are showing up in my Power BI groups
I was just working on something in Power BI and saw some weird behavior. I had created some groups in Power BI (learn how to do that here) and a weird little peccadillo popped up. I had opened my Power BI Desktop file earlier on in the morning. Later on, I realized I wanted to…
-
Create PivotTable unsuccessful – Power BI and Excel
Every once in a while, I’ll Google something and get 0 results. I hate that. This time, it was me trying to connect to a Power BI data model through Excel so I could use the cube functions and make a fancy little Excel-based dashboard. I swear, I don’t know how anyone does anything in…
-
Easily building an income statement in Power BI
Want an easy way to create either an income statement or a balance sheet in Power BI? Here’s one straightforward approach that worked for me!
-
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…
