Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
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…
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…
The pagination options in Power BI are a great way to break your Power BI reports down into manageable bites. Adding more pages can give a designer more real estate to work with and more ways to break down data. On the flip side, too many pages makes the Pages Read more…
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…
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…
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…
Power BI releases new updates frequently, and sometimes those updates are only available as a preview feature. In other words, the feature is not ready for complete release but it will work in most situations. This blog post will detail how top check for and enable preview features in Power Read more…
At first glance the Table and Matrix visualizations in Power BI look similar. Both display data in a table format that reminds the user of Excel. However, understanding the difference between the Table and Matrix visualizations in Power BI is important to displaying data efficiently. The basic difference is that Read more…
Power BI’s existing data refresh schedules are limited and remembering to manually trigger a Power BI refresh can be difficult. One of the benefits of Power BI is receiving real time data, and Microsoft took steps to enhance this benefit by adding an action in Flow to automatically trigger a Read more…
Microsoft is continuously releasing solutions and updates to existing products, that can make staying on top of the tools that are available through the O365 platform a difficult endeavor. One of the most widely marketed solutions that Microsoft has been trumpeting is called the Power Platform and is made up Read more…