Category: Power BI
-
Power BI Copilot and How to Turn it On
I tried to add Copilot into my Power BI workspace and ran into a wall. “Copilot isn’t available in your workspaces.” None of my workspaces had the capacity for it. The free trial doesn’t cut it I clicked into my profile and hit “Free trial” to kick off a Fabric trial, figuring that would unlock…
-
What does the future look like for business intelligence?
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 always rested on the human: make a decision, take an action, push forward. I think that’ll…
-
Easily filter by Multiple Values in a Single Column in Power BI
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 values Let’s say you have this data: You want to filter for…
-
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…