Kategorie: Allgemein

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… über…

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…

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 über Business Central SaaS Exporting Database Backup and Restore it on your Sql Server — Roberto Stefanetti NAV & Business Central Blog

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 über Pivoting Data for Speed — Phil Seamark on DAX

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 […]…

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 über Good Practice: Always Display the Reporting Environment — Business Intelligence Insights

If you’re a frequent reader of this blog, or a frequent user of Power BI dataflows, you probably know these things already: Power BI dataflows are workspace-level objects in the Power BI service that enable data reuse through self-service data preparation. Power BI dataflows store data in the CDM folder format in Azure storage. CDM […]…