When the Report Usage Metrics Report stops refreshing

Have you ever had a Usage Metrics Report just stop refreshing? At the bottom you'll see a little message that tells you to check the credentials. But you don't have access to the Usage Metrics Report dataset in the list of datasets in the workspace because it's hidden! So even if you wanted to delete… Continue reading When the Report Usage Metrics Report stops refreshing

DAX measures treating slicer selections with *and* instead of *or* behavior

The general idea When using slicers in Power BI reports, multiple selections filter data with OR logic. For example, if you have a slicer with products and your visuals are displaying total number of invoices, then when "bicycles" and "helmets" are selected in the products slicer your visual will show the number of invoices that… Continue reading DAX measures treating slicer selections with *and* instead of *or* behavior

My favorite clean and simple way to combine csv files in Power BI

One of the unsung heroes to me in Power BI desktop (or Power Query in Excel) is how wonderfully simple it is to combine csv or Excel files from a folder. Maybe it's not totally unsung, but I think it's an everyday problem that many people have to deal with. It could easily be an… Continue reading My favorite clean and simple way to combine csv files in Power BI

Adding a row rank based on a different column with Power Query

Suppose you have two columns of data, one is something to group on and the other is something you could use to rank the rows. It might look something like this (grouping on Person, ranking based on Event Date): Now let's say that you'd like to use Power Query to add a column that ranks… Continue reading Adding a row rank based on a different column with Power Query