Power BI with as little data as possible in the cloud
The "normal" Power BI variant (everything in the cloud) would be to upload large Power BI files containing all the raw data to the cloud. This creates a so-called "semantic model" in the cloud, which the report itself can consume in the same way as other reports. This "semantic model" is technically nothing more than the SQL Server Analysis Services Engine, with which [...]
Welcome Manuel!
Welcome aboard - Manuel John! We are pleased to introduce our new contributor, who joins us with an impressive background in computational linguistics. In his studies, he conducted a fascinating project training a ChatGPT model to generate plays in the style of Goethe and Schiller. His solid knowledge of [...]
BI Technologies in Transition: Today vs Tomorrow
Changing technologies for BI Microsoft technologies are constantly evolving. In the following, I would like to present various compilations of technical components that can be used to implement professional business intelligence projects today and in the future. Current technology stack for SQL Server On Premise Customers who already have a SQL Server in-house due to other projects (at least Standard Edition) come [...]
Using sort columns to define the category sort order in the "Fields" parameter of Power BI.
In Power BI, the correct sorting of categories is crucial to make sense of data in reports and visualizations. The Fields feature allows you to select fields and dimensions to use in a report. However, setting up an appropriate sort order for these categories can be challenging. Here we explain how the sort order of categories [...]
Field Switch in Power BI: Simplify your data analysis with dynamic column selection
Effective data analysis is critical for companies that use Microsoft Dynamics NAV, Navision and Business Central as their ERP systems. Power BI, Microsoft's powerful business intelligence tool, offers a feature called Field Switch that lets you dynamically select columns and simplify your data analysis. In this article, you will learn how to use the Field Switch [...]
Data-based color change of rows in Power BI tables or matrices
Visualizing data in table format is an effective way to present information and gain insights. In Microsoft Dynamics NAV, Navision and Business Central, popular ERP systems from Microsoft, data analysis plays a crucial role for businesses. In this article, you'll learn how to change the color of rows in Power BI tables or matrices based [...]
Display animated GIFs in Power BI
In today's business world, data visualization and business intelligence play an increasingly important role. Companies are looking for ways to present data in an engaging and easy-to-understand way. One popular solution for this requirement is to use Power BI, a business intelligence tool from Microsoft. In this article, we will focus on how to use animated GIFs in [...]
Chat GPT or AI consultant: Will business intelligence jobs be replaced?
In the rapidly evolving world of artificial intelligence and automated technologies, the question is whether chat GPT (Generative Pre-trained Transformer) or AI consultants pose a threat to traditional business intelligence jobs, especially those associated with Microsoft Dynamics NAV, Navision and Business Central. In this article, we explore how these technologies work and what impact they have on [...]
Power BI Helper: The external tool to support metadata management in Power BI Desktop
Power BI Desktop is a powerful application for creating interactive data visualizations and reports. In complex Power BI projects, especially in conjunction with Microsoft Dynamics NAV, Navision and Business Central, effectively managing and monitoring metadata can be a challenge. In this blog article, we introduce you to "Power BI Helper", an external tool specifically designed [...]
Handling multiple date values in Power BI with DAX-Measure and a single date dimension table
When analyzing data in Power BI, you may need to work with multiple date dimensions. In some cases, you may want to use only a single date dimension table and associate the different date types such as sales date, delivery date, and due date with it. In this blog article, you will learn how to use a single date dimension table and the USERELATIONSHIP [...]
