Power BI – Code

Power BI – Switching from Import to Direct Query

September 22, 2020 by Shaun Geisert

When getting data for Power BI, the default setting is “Import” and not “DirectQuery”. Import doesn’t work too well for me at least, because my data sets are all changing every day. Here are some tips in converting a project to instead use DirectQuery. First, back-up your file and then open your new copy (of … Read more

Power BI Slicer For Multiple Columns

September 9, 2020September 9, 2020 by Shaun Geisert

Recently I had the need of creating a slicer in Power BI that would filter against different columns in a system storing the same type of data: case types for Student Legal Services. For purposes of remembering how this functionality was accomplished, I’m documenting it here: https://www.sqlbi.com/articles/creating-a-slicer-that-filters-multiple-columns-in-power-bi/#