WhatTheFact_Logo_Transparent_353x76px

This post is also available in: Deutsch

Integrate Power BI Report with complete interactivity in OneNote

This post is also available in: Deutsch I recently received a tip from a colleague at work, which was also something I hadn’t seen before. More precisely, it was about integrating a Power BI report with all reporting options into a OneNote page. For this purpose, I use the report with the manual fonts as an example. The report has to be shared on Power BI Services (powerbi.com) via Share –> Embed report –> Publish to web (public): Warning: When sharing via “Publish to web (public)”, the report can be viewed by anyone who knows the link. This is highly dangerous and should only be done with reports that are intended for the public anyway! In the dialog that appears, you can specify a few options such as the size of the report. Then the report link can be copied: In OneNote, the copied link can simply be pasted and the report appears fully interactive and embedded in the OneNote page: Works only with Public Shared Reports However, there is one major limitation. At the current time, the feature only works with publicly shared reports. This means that anyone who is in possession of the link will be able […]
CustomColumn
This post is also available in: Deutsch If you find a date or datetime format in UNIX format, the first thing you wonder is what it is all about or how you can display it “normally”. This is because the UNIX date format looks like this: What exactly is UNIX Timestamp? To find a way to convert this, we first need to understand what the number means. The UNIX timestamp is the number of seconds since January 01, 1970. You can read exactly about why it is like this in the Wikipedia article. I want to focus on finding a solution for this problem. In the above example, 1604135115 seconds after 01 January 1970 is 31 October 2020 at 09:05 AM and 15 seconds. Update February 20, 2023: The classic UNIX timestamp is, as said, the number of seconds since 01/01/1970. However, there are some programming languages and APIs that specify the timestamp in milliseconds since 01/01/1970. In such a case, the solutions given below must simply be divided by 1000. Some examples of this can be found at the end of the article. The timestamp for a value in 2023 is then not 10-digit as indicated above, but […]
This post is also available in: Deutsch For a while, it was only possible to provide a Power BI report in multiple languages using workarounds. Recently, the enhanced dataset metadata has made it very easy to change the language of a report in Power BI, making it multilingual, for example in German and English. Since the Power BI September Update, the enhanced dataset metadata is now the standard for metadata, upgrading a Power BI report almost to the level of an SSAS Tabular Model. Enhanced dataset metadata enables SSAS Tabular functionalities One of these new capabilities is to offer the data model of each Power BI report in multiple languages. The easiest way to maintain multiple languages is currently using Tabular Editor. As an example we use the following simple report based on the Adventure Works database: And the tables to be translated: Once the Tabular Editor is installed, it can be started under “External Tools” with connection to the open file: Maintaining translations in the Tabular Editor In Tabular Editor we see the folder “Translations” at the very bottom, where we are able to create a new language for our data model by a click on the right […]
image 12
This post is also available in: Deutsch Many companies are trying to achieve a consistent appearance and have corresponding or Corporate Identity / Corporate Design (CI/CD) guidelines. As a reporting platform, Power BI should of course be no exception and fit into the corresponding specifications. However, this is often a big question mark, because at first glance there is no option to add additional fonts in Power BI. There is only a selection of standard fonts to choose from: […]
This post is also available in: Deutsch When you often work in different IT environments, you can easily reach the point where a customer is working with a different Power BI desktop version than the latest one. As a developer this can become a problem, because the PBIX files are generally not backward compatible to older Power BI versions. As a result, the completed work may not even be accessible to the customer. Why the download from the Power BI Blog does not work In the past I used to google for the wanted release article in the Power BI Blog and then download the file there. Unfortunately, this approach no longer works, as the links now all point to the latest release. This may be good for end users, but as soon as you need a specific version, it is a disadvantage. The solution the update archive Fortunately, there is a solution after all. Microsoft provides at the following link an archive of all releases, including updates, a video about the update and the corresponding setup files since the release in 2015. https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive So it’s better to save the link as a favorite if you have to change […]