Part 2 – Bulk-copy pages
In part 1 of this series, we used DAX – scripting to bulk-copy measures. The next step is to bulk-copy pages with the new logic. To do this we can use the Power BI PBIP functionality and note ++. In our situation we added two (2) new fact tables to the model with an additional […]
Part 1 – DAX scripting
There is a data model. This data model consists of one (1) dimension table and three (3) fact tables. Each fact table consists of one (1) column with the dimension values next to it with a calculation column with revenue, costs, discount. For each fact table, the revenue, costs and discount must be calculated separately. […]
Data source (methodology)
Introduction Microsoft Power BI is originally a data visualization tool. It cannot function without a data source and therefore it is crucial to think carefully about the type of data that will be fed to Microsoft Power BI.Microsoft Power BI can handle many types of data sources. This can vary from an Excel file to […]
Third party tools
A third-party tool is a piece of hardware or software developed by a company other than the product manufacturer and designed to improve product performance. There are many third-party tools available for the usage of Power BI. The most commonly used are Tabular Editor, Dax Studio, ALM Toolkit. In the remainder of this article each […]
Solving a data error message.
A beautiful dashboard has been created, but according to the end user of the dashboard, the data is incorrect. The cause is not clear. It can be due to several factors; or the data itself, the different parts of the Power BI dashboard , an external factor such as a page filter, a wrongly chosen […]
The Definition Of A Gateway
You have probably heard about the phrase “gateway”. But what is meant by this phrase? In an easy explanation: a gateway is a (data) bridge between an on-premise data source and a Microsoft cloud service. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. An one-premise data source […]