Power BI

I have been holding on to a copy of Satya Nadella’s book “Hit Refresh” for quite some time. With all the Power BI goodness, the [...]

Case In a previous post you wrote that Microsoft Flow could help to delete records in my PowerApps. How do you add a Flow to PowerApps? ...

See a transparent history of changes to Power Query M functions by using GitHub.

Learn how to create an automated report in Google Ads (AdWords) that gets imported into Power Bi using Ads Script and Google Sheets. It’s based on an Excel Power Query report done by Dan Zrust – so a big shout out to him. As many of my clients use Google Ads conversion tracking code I can’t … Continue reading "Import Google Ads Data Into Power BI For Free"

In my previous post, I shared a winning combination of Forms, SharePoint, Flow, and PowerApps. In this post, we’re going to dive in deeper into the PowerApp I created. I wanted to take this a…

Premise In this post I’ll demonstrate how to trigger a Microsoft Flow from Microsoft PowerApps. PowerApps are indeed very useful in submitting forms to the server. Combined with Microsoft Flo…

PowerApps gives you the opportunity to extend your SharePoint lists so that it can give just that much better experience for your users. However, there are still some things that need a little bit extra attention, such as lookup and people fields. In this blog, I will explain how you can use these field types […]

In this article describes how to implement responsive layouts with SharePoint View Formatters.

In late September, we announced the public preview release of the Power platform Admin Analytics. In that post we discussed a couple of upcoming reports including sharing and connectors. We have honored that commitment and I am happy to share that both the sharing and connectors reports are available in Microsoft Flow Admin Analytics.

This week you may have noticed that some parts of the Microsoft Flow experience have changed. As a part of the October release, we are overhauling several key aspects of the Microsoft Flow portal and designer experiences to make it easier to navigate and find actions.

In a recent announcement, Microsoft shared news about a new Application Lifecycle Management (ALM) capability for PowerApps and Microsoft Flow. This new capability is built upon the Common Data Service solution system. In this blog post, we will share details about how Microsoft Flow makers can use Solutions to bundle related flows (and apps) within a single deployable unit.

In budgeting reports, a common requirement is to show future sales forecast and actual sales volume on the same line chart. This article describes how to ac

While the native function Text.BetweenDelimiters will only return one occurrence of a string found between 2 delimiters, my new function will fetch all of them.

In this video, we are joined by Buck Woody. Buck is a data scientist at Microsoft. We work together to show how you can easily visualize Microsoft R in Power BI. We use Microsoft R Open and then move onto Power BI Desktop. The example used in Microsoft R Open is the Anscombe’s quartet. Download […]

In this video, we look at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop. This feature is incredibly powerful when it comes to data matching and can be adjusted to meet your needs.

BI Power Hour Quick Tips for Aggregations & Composite Models in Power BI (@GilbertQue) Create a Power BI Slicer Panel (@ExceleratorBI) Create Event Calendar In Power BI (@DhruvinShah16) On-premises data gateway October update is now available Power BI Desktop October 2018 Feature Summary BONUS ITEMS: Transform NAV accounts totaling to list of accounts (@TheBIccountant) Optimizing […]

I had seen some questions in the Power BI Community when asking how to run reports or dashboards in a browser screen so that they cannot see they buttons on the bottom left hand side. In my example…

Here is my weekly Power BI related round up, I hope that you find this information relevant and keeps you up to date with everything that is happening with regards to Power BI. Power BI – Webinar o…

I had a requirement where the customer wanted the difference between 2 values in a table. The challenge here was that because the values are already part of the table, I had to find a way to get th…

As expected this week with SQL Pass, there has been a whole host of new capabilities and features in Power BI, so please see my roundup below with the relevant links below. And even though there is…

I was delivering my standard Power BI training course, and there was a question from one of the users which was ‘Is there a way of clearing all the slicers you have selected, so if you are do…

Planning, forecasting & simulation are some of our key focus areas. Recently, we did some benchmarks what the optimal configuration (Azure SQL Table / Azure SQL Table in Power BI / SSAS connected to Azure SQL with Direct Query) for typical planning scenarios in Excel is. Acterys (a solution by one of our group companies) enables users […]

This is a quick tip on automated testing with Power Query. I loved Nar's post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For my part, I sometimes use hidden pages in Power BI reports to assure myself of

I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog Post by Matt Allington, where he stepped through an

It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a website inside of a Power BI report. My initial instinct was “Of course! But how?” It turns out that this is very

[Part 1 of this series can be found here and part 2 here] The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are…

I’m at the PASS Summit this week, and in this morning’s keynote there was a demo of the newly-released Azure Data Studio – a modern, cross-platform tool for managing and querying…

If you are following me on social media, this video will not be new. Two days ago I received my print copy of the book. The book is real 🙂 I was so excited about it, so I had to fool around and create this video. A journey of one year has ended. I would …