Sample Power BI Data to Practice With

When beginning to use Power BI, one of the most common questions is always “Where do I go to get sample Power BI data I can use?”. Unless you are willing and able to create your own datasets, downloading an already generated dataset provides a helpful place to start. Thankfully Read more…

By Jon

External Tooling in Power BI

External tooling is incredibly useful for extending capabilities in Power BI that might not be native to the application. As an example, the DAX editor in Power BI itself can be really cumbersome to develop larger DAX statements. DAX Studio negates this issue by giving you a dedicated environment to Read more…

By Jon

Fact vs. Dimension Tables in Power BI

Figuring out the difference between fact and dimension tables in Power BI can be complicated. In this blog post we’ll go over the difference between the two and when they should be used. When you are building a data model fact and dimension tables are the two types of tables Read more…

By Jon

Benefits of Variables in Power BI

Variables in Power BI can be a very powerful way to enhance your DAX expressions and expand the possibilities of what DAX can do. Before Power BI supported variables, needing to use CALCULATE and the EARLIER function were cumbersome and created difficulties for data modelers. Today, those difficulties can be Read more…

By Jon

Power BI Pro vs. Premium

Along with the free license, Power BI offers a couple of different licensing options. The main license types to worry about are called Premium and Pro. Which license you need largely depends on the audience that you need to present your data to. Power BI Premium is heavily geared towards Read more…

By Jon

Date Tables in Power BI

For many entry level Power BI developers, using the built in date table in Power BI will work fine. Behind the scenes Power BI auto creates a date table based on the date values in your data. However, many experienced Power BI developers want more control over their date tables Read more…

By Jon

How to Add a Power BI Bookmark

Bookmarks in Power BI are a great way to create powerful reports and have a little more control over how the user interacts with your report. Essentially, creating a bookmark captures the Power BI report in exactly the configuration and layout that it was when the bookmark was added. Once Read more…

By Jon