Power BI

This change will make Tenant level administration available for PBI service admins

Data maturity measures and evaluates a business’ habits, behaviours, and tools.

Can calculating your organisations Net Promoter Score be achieved using Microsoft Forms Pro? You bet it can! Let's look at how to do this.

You have created a Power BI report with many visualizations and calculations, however, it is slow! And the slowest part of that is the report page with a matrix or table visual in it! Why that visual is so slow? Is this the problem of Visual in Power BI? or Power BI problem at all?…

If you were looking to upgrade a Power BI model to Analysis Services Tabular, hopefully you decided to do it before March 1, 2019, that was the day Microsoft decided to remove the tool from Azure. …

See how to create and use App Navigation in Power BI. You can control the navigation area when publishing Power BI Apps. Even include external content with your apps!

This Power BI blog post uses Power Query to show to get an output from a table as a value, which can then be used as part of another M Power Query

Resuming from Last Week Last week’s post left off here: most BI still relies on the storage layer (SQL or its many cousins) to be the brain, and storage layers are terrible brains because they were designed for storage, not for analysis. This week, I hope to explain the following points: Storage brains are siloed

Canvas apps now support changing the environment within the Common Data Service connector. The default behavior hasn’t changed and existing Common Data Service connections will continue to use the canvas app’s current environment. When adding a new data source, we now display the environment at the top of the list of entities. The default appears … Continue reading “Enable Common Data Service connector to select an environment”

As I have discussed in part 1 and Part 2, the new possibility of creating machine learning without writing any Python or R codes is so amazing. In Part One, the difference between Azure ML Studio (the traditional one) and the Azure ML Services (new component) has been very briefly explained. (I will write…

Dimensions and Fact tables are the two essential parts of building a data model, and their relationship in the form of Star Schema is the best practice of doing the modeling. However, these are all theories until you really experience it in a real-world example. In this article, I want to put everything you learned…

Make your plan and embrace what’s next for your business. Don’t miss Microsoft Business Applications Summit, coming to Atlanta, Georgia, June 10 – 11, 2019. We’re gearing up for an amazing 2+ days filled fresh approaches, the latest technologies, and new ways to power digital transformation at every level. Save your seat today – … Continue reading “Last chance! Register for Microsoft Business Applications Summit today”

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup139 Tech Video: https://guyinacu.be/time Sources Power BI – Dynamic TopN + Others with Drill-Down (@gbrueckl) Reviewing the Performance Analyzer in Power BI (@HavensBI) Power BI Report Server May 2019 Feature Summary How to govern Power BI visuals inside your organization Designing custom navigation […]

I often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes…

Understanding the if statement inside of Power BI / Power Query and how Conditional Columns can be created through the UI and a Custom Column.

I blogged about the various ways to use Measure tables and Measure Sub Folders in Power BI a few weeks back. I discussed why measure tables may be required, and also a few reasons why you may choo…

As a footnote to my previous post on storing large images in Power BI, I thought all you M nerds out there would be interested to read about a strange performance quirk I noticed while writing the cod…

This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. The

Keyboard shortcuts for canvas apps

Last month Microsoft announced on the Power BI blog an exciting new capability: AUTOMATION & LIFE-CYCLE MANAGEMENT ‘Refresh Now’ API provides unlimited data refresh for Power BI Embedded and Po…

“New Feature Friday” returns for the latest feature update for Paginated Reports. We’ve just rolled out support for five new attachment options for your e-mail subscriptions in Power BI. In addition to PDF, you can now choose one of the following new attachment types for your subscription(s) – PowerPoint presentation (PPTX) Excel Workbook (XLSX) Word … Continue reading “Enhanced Attachment Support for Paginated Reports E-Mail Subscriptions is Now Available”

(2019-May- 24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure Data Factory (ADF) last year as a priv...

I get many questions about Microsoft Flow related to the many posts that I have written in recent years. Earlier this week I got a question related to my posts Do you process your invoices with Micros…

Planner Tasks Have you started to use Microsoft Planner across your teams in Microsoft Teams? In each team you create some tasks and now you would like to have an overview of all the tasks across the …

Weekly Power BI RoundUp where it covers all the latest Power BI details over the past week including this week the release of Power BI Deskop for May 2019