When I was a Sophomore in college, I got a job doing tape backups at a food ingredients company. The developers there maintained a stack of paginated reports for the managers in the corner offices. At the time, I thought it…
Your Power BI model is fed by a data warehouse, and you'd like to make some reports, but now your Customer table has several entries for each customer instead of one. Then, you filter out the obsolete versions of customers,…
In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a title, info is exported with a generic title of "Data."…
I'll get to parameters for dataflows in a bit. To begin, let's talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service. They are…
Quick tip for DST Refresh Date function Power BI Service. I'll put the code up front, and explain it below. I'll also say a bit about how to use it at the end. The United States and other places, like…
Here are 2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports. But there are also dashboards. Dashboards are sites to pin key visuals. People can view but not interact with them. They can click…
This is a quick tip on automated testing with Power Query. I loved Nar's post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For…
Data Warehouses: What Do I Know? Well, I'm no expert. I learned Power Pivot and Power BI through Excel. What I know is from helping to build a SQL data warehouse. That is, I've worked with a data warehouse pro.…
Today, we'll look at Power BI workspaces, apps, and how to keep changes from mucking up reports. In the software development lifecycle, a distinct space to test new reports ensures consistent results. Moreover, it's part of good governance. This post builds…
What I didn't know about the Power BI Service (PBIS): I've been using the Power BI Service (PBIS) daily for five months, and before that, I consulted on challenging DAX problems for over a year. So, when I attended a…