Creating a Power Query function browser – #powerbi
One of the best functions in Power Query (M) is for sure the function =#shared that inside the Query editor lists all the functions in M and in your current pbix file. Picture 1 Result of =#shared But…
This is it - It's day 24 of my #24DaysPowerPlatform! When I had the first idea of this blog series, it was just a vision - and now - at the end of this series I hardly cannot believe that I kept up an…
What has happened in the DAX world in 2018 - SQLBI
We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is go
As Power BI grows to become a superset of Analysis Services functionality, a lot of that functionality will evolve as it becomes available. Incremental data refresh is a great example of how Power BI …
Data Privacy Settings And Data Refresh Performance In Excel And Power BI
I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to obs…
Like a diamond in the sky. How I wonder what you are! Twinkle, twinkle, little star, Twinkle, twinkle, little star, Up above the world so high, How I wonder what you are! Confused? You were probabl…
We start my Christmas series with my favourite new thing I found in the past few weeks, Enhanced Groups. This post does a quick overview of a great new feature in PowerApps, Enhanced Groups. This feature is currently set to “Experimental”, so might well vanish at any moment. For now, it can help hugely in […]
[2nd day of Xmas] – Exploring the PowerApps Dialog Box
For the second day of my Christmas series, we are going to build a simple dialog box. When designing an interface you occasionally want to explain the consequences of proceeding to the user and ask for confirmation using a dialog box. For example, this will delete all records relating to this user, do you want […]
Encodian - New PDF Conversion, OCR, Watermark and Image Clean-Up capabilities in Flow
Hey Flow Fans! My name is Jay Goodison, one of the co-founders of Encodian and this post covers our recently released 'Encodian' connector which provides a new set of robust actions for creating, watermarking, securing, OCR'ing and merging PDF documents as well as image clean-up operations, bringing...
Power BI Consulting Firms and Their Services - As Seen on AppSource
Update: Check out the latest report here including coverage worldwide coverage, and drill down to United States, United Kingdom, Canada and Austrlia. Now offered as a paid report. Get a report to support DataChant. Microsoft offers partners to introduce their consulting services through AppSource (For exmaple, you can find here the services which are related to Power BI …
Power BI is not so much a data visualization tool as it is an end-to-end business intelligence platform that ends with visualizing data. Marco Russo approached this well when he explained the differences between a more robust model-based tool and a narrowly scoped report-based tool. While visualizing data in Power BI may sometimes be a bit…
On-premises data gateway December update is now available | Microsoft Power BI Blog | Microsoft Power BI
We are excited to announce that we have just released the December update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release: – Enhancements in SAP BW connector – The On-premises data gateway now includes the December version of the mashup engine The … Continue reading “On-premises data gateway December update is now available”
<p>Performance is a top priority for the PowerApps team. There are major efforts currently underway to improve performance around app load time, the designer experience in Studio, connectors res…
<p>Today, we’re thrilled to unveil the newest addition to the Office Template series: Shoutouts. Like the Out of Office app, it is a brand new template, available to customize, use as is, custom…
<p>With its breadth of scope and depth of data, Microsoft Graph is quickly becoming the go-to API for app makers looking to increase productivity and build for business scenarios. The PowerApps …
Microsoft just released the second in a series of 10 Microsoft PowerApp Templates that demonstrate how to make PowerApps that integrate with Office 365 Products
APPLIED MICROSOFT POWER BI (3rd Edition) (BRING YOUR DATA TO LIFE!)
There is a newer edition of this book Introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that d…
If you're a Power BI administrator you're probably already familiar with the Power BI Management module of PowerShell cmdlets. Additionally, as an alternative to PowerShell, you may have seen the rece…
In this article, we are going to learn how to use Power BI Desktop Q&A functionality to enable users to ask the question from the data set and easily get the results without any configuration or write complex codes.
Making Power BI Drillthrough Return The “Right” Rows When You Use It With Complex Measures
When an end user sees a strange value in a Power BI report, their first reaction is usually to want to see the detail-level data from the underlying table. Power BI’s drillthrough feature is a grea…
There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your Power BI reports. …
Today I woke up with an interesting question, about how to show a selection of months in a nice way, detecting contiguous selection. You can easily underst
PowerApps Canvas App Coding Standards and Guidelines
Today we are happy to announce the release of the PowerApps canvas app coding standards and guidelines white paper! Why did we create the white paper? Creating a simple canvas PowerApp is easy. But as the complexity of your app increases, care must be taken to keep your apps maintainable and performant. Across the web … Continue reading “PowerApps Canvas App Coding Standards and Guidelines”
Introducing the new view designer for model-driven apps
<p>Yesterday we announced the new model-driven designer coming to preview, and today, I’d like to announce that we’re also releasing the new view designer in preview. The exp…
24 Days of PowerPlatform – Day 19 – SSRS in Power BI
The history of reporting tools in the Microsoft reporting universe is a long story and many tools have taken part in that journey (SQL Server Reporting Services, Performance Point Services, Excel,…). …
The Complete Power BI Infographic – Update for Dec 2018
I recently had a look at my last version of my Infographic and I realized that I had not updated it for a few months and there has been a lot of incredible additions to the Power BI ecosystem. My i…