Welcome back! This is part 2 of our Dashboard In a Blog (or Two) series. If you missed part 1, click here [CD1] to catch up and then come back here to continue with part 1. Go ahead and open up Power BI and the file you saved in part 1. When it opens, you willRead more
If you’ve been watching the Power BI space for some time, I’m sure you’ve seen many offers to go to a seminar or watch a webinar to show you how easy it is to build a “Dashboard in a Day” or even a “Dashboard in an Hour” with Power BI. I’ve seen many of theseRead more
I recently read a post on the Power BI blog about a new enhancement to the scheduled cache refresh process with DirectQuery. The post does a great job of explaining how to implement it, but I wanted to write about why you may want to consider this for your environment. As you have probably noticed,Read more
Power BI is the newest business intelligence offering from Microsoft. It’s a product that a lot of people have been talking and thinking about for the past year or two, and it is gaining more and more traction every day. I like to refer to it as “The best tool that people don’t realize theyRead more
There are many types of indexes in SQL Server. One of the less commonly-used types is a Filtered Index. This blog explores scenarios for using a filtered index, so that you know when it should be applied to be most effective.
