The following Map / Landscape was created by me, after a Power BI coaching the customer asks me: „Hey, now we know Power BI and we can create Reports. Whats now you job?“ – Therefore I havn’t a good answer and I started to tell him the whole universe. After that, I created a Min…
Sehr gutes Video. Hier wird auf anschauliche Weise gezeigt, wie einfach ein Dataset in einen dataflow ausgelagert werden kann, um so ein zentrales „repository“ aufzubauen…
At this point I’ve said „Power BI dataflows enable reuse“ enough times that I feel like a broken record. What does this phrase actually mean, and how can you take advantage of dataflows to enable reuse in your Power BI applications?
This Power BIte video is a bit longer than its predecessors, and part of this is because it covers both the problem and the solution.
The problem is that self-service BI applications often start out as one-off efforts, but don’t stay that way. At least in theory, if the problem solved by the application was widespread and well understood, there would be an existing solution already developed and maintained by IT, and business users wouldn’t need to develop their own solutions.
Successful applications have a tendency to grow. For self-service BI, this could mean that more and more functionality gets added to the application, or it could…
Ursprünglichen Post anzeigen 286 weitere Wörter
Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations can take advantage of specific optimisations. When RI issues exist in an IMPORT model, complex expressions will not be able to use all…
This is a series of posts and exercises from a recent full-day workshop called Next Level Power BI. Check back for additional lessons and freely post your questions and feedback in the comments section after this post. Power Query is a modern data acquisition and transformation technology and it is the „Get Data“ component of Power BI and many other Microsoft tools. The query script language of Power Query is known as „M“ or the Microsoft Data Mashup language. The menu options and selections in the Power Query Editor interface build this „M“ script for you but to use Power Query at an expert level, you must understand fundamental concepts of the language. The post will step you through some essential mechanics of the language to build the necessary fundamental skills.
Business Central SaaS Exporting Database Backup and Restore it on your Sql Server Since some days, Microsoft has activated the feature for downloading a backup… 587 weitere Wörter
Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI datasets: https://blog.crossjoin.co.uk/2016/07/08/excel-2016-pivottable-mdx-changes-lead-to-big-query-performance-gains/ I know it sounds boring and not something you need to worry about but trust me, this is important – […]
In this article, I’m going to describe a technique you may wish to consider to help speed up your Power BI reports. This specific technique is designed to help speed up reports that show common period comparisons such as: 1.409 weitere Wörter
This is still one of the most common dataflows questions: what’s the difference between Power BI dataflows and Power BI datasets? For the last year I have resisted tackling this question head-on. This isn’t because it’s a bad or „dumb“ question. Just the opposite – this is a very simple question, and the simpler a […]
Und wer einen Workshop vorzieht und es nach München schafft, dürfte hier gut aufgehoben sein:
When you work on real-world projects in power BI, you would probably have different environments Like DEV, UAT, Pre-Prod and Prod. It is important for you and your audience to know what the data is coming from. 43 weitere Wörter