The purpose of this article is to outline a set of guidelines and recommended practices for managing Microsoft Power BI projects. This guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Again, this guide is primarily focused on the work performed by the IT-managed BI Solution Developers for formally-managed BI projects. Topics included in this guide: Solution Architecture Managing Power BI Desktop Files Datasets and Reports Version Control & Lifecycle Management Workspace and App Management Data Model and Power Query Design Guidelines Dimensional Design Query Optimization Managing Dataset Size with Parameters Implicit and Explicit Measures If Users Need Excel, Give them Excel Certified & Shared Datasets Enterprise Scale Options

über Power BI Project Good and Best Practices — Paul Turley’s SQL Server BI Blog

I have been asked to produce a simple construction report, we need to show the last 4 weeks of actual progress data and 6 weeks of forecast and to make thing a little bit complex the average installation since the start of the project, nothing special three measures, average to date, install per week and […]

über Build asymmetrical Pivot table in PowerBI — Project Controls blog

If you’ve ever built a BI solution it’s likely you will have had to integrate third party data, and if that’s the case you will know how painful it often is to get your hands on that data. Badly designed portals you have to log into every week to download the data, CSV files emailed […]

über Sharing Data Between Organisations With Azure Data Share — Chris Webb’s BI Blog

One of the things you should know when working with PowerQuery is that you can get a list of all functions in M by adding a blank query and use the #shared expression to get all the functions. This can be turned into a table by clicking the „Into Table“ button on the ribbon and […]

über How to get help for any function in #PowerQuery — Erik Svensen – Blog about Power BI, Power Apps, Power Query

This planned Blog-Series is dedicated to Power BI with Paginated Reports. The first part handles who to start with this Feature. Paginated Reports are known from Reporting Services to create pixel perfect fitting reports, especially for Printouts and it is more an Feature of Power BI. Before Power BI comes to on premises, it was…

über Power BI Paginated Reports – 1 of ? — flip-it.de :: SQL, BI and more

At the airport of Copenhagen (CPH) eating my favorite burger. (Aamanns Burger). Then writing a blog. This is an awkward blog, a blog that was asked for by my colleague Jan when I spent a few days at our office. He asked if I could blog something about converting from C/AL to AL with the […]

über C/AL to AL, but better & faster — Mark Brummel Blog | Microsoft Dynamics NAV