Posts:
Power BI Hierarchical Slicers
BY: David Rohlfs Introduction Hierarchical slicers are a great way to enable a report builder to simplify their slicers and to simplify their report. Hierarchical slicers allow for a field to be subcategorized under another field. This allows the report... (more...)
Power BI Sort by Column
By: David Rohlfs Introduction Sort by Column is a very useful function to format your data. It is commonly used when you are creating tables, matrixes, slicers, and some graphs. This function can help to arrange your data in a way that is more specific... (more...)
Power BI and Group BY
BY: David Rohlfs Introduction One of the best things about Power BI is that there are almost always multiple ways to do everything! One of the functions that I have learned to enjoy is Group By. Group By has many different uses and can be very helpful... (more...)
Power BI Preview Features
By: David Rohlfs Preview Features are a way for Microsoft to have a soft launch of features in their Power BI desktop. These features are added, updated, changed, or removed with new updates. This is a way for users of Power BI to give insight and review... (more...)
Power BI Filters VS Slicers
By: David Rohlfs Filters and Slicers are two commonly used features in Power BI Desktop. Because of the characteristics of filters and slicers, they have many common uses which are quite similar for the report builder. The main reason to choose the use... (more...)
Power BI Column From Examples
By David Rohlfs Column from examples is a simple way to avoid using functions and to avoid using DAX or investigating the M code that you hope should work for what you need. It allows the user to make changes in a preview column and Power BI will recognize... (more...)
Power BI – Apps, Workspaces, Dashboards, Reports and semantic models Defined
By: Collin Quiring With any specific technology, understanding the terminology of the toolset is important. And, with the term “application” and the way that Power Bi is used on Desktop and Service I thought I would give an attempt at helping give... (more...)
Why Create a Date Table in Power BI?
By: Collin Quiring We have trained thousands of folks on Power BI and have worked with hundreds of companies. We always recommend a date table be created in Power BI. And we often are asked why we are so strongly recommending a date table. Here... (more...)
Power BI Desktop Refreshes, but Service Errors on Refresh
BY: Collin Quiring There are a number of potential reasons when a report will refresh in the Desktop but not in the Service. In this case, the error that we received was: “error”:{“code”:”ModelRefresh_ShortMessage_ProcessingError”,”pbi.error”:{“code”:”ModelRefresh_ShortMessage_ProcessingError”,”parameters”:{},”details”:[{“code”:”Message”,”detail”:{“type”:1,”value”:”Information... (more...)
Power BI Report (Visuals) Versus Table Versus Query Versus Transform Data Versus
BY: Collin Quiring In Power BI we have a few views on the left side of the main screen, and we have the Edit Queries/Transform Data option as well elsewhere. What is the difference? What do they each do? What is the main purpose of each? In Power BI Desktop,... (more...)