Power BI

When you build flows in Microsoft Flow or apps in PowerApps most likely you will be using data of some sort. Where should you be storing the data? In this post i'm considering SharePoint lists and I'm…

There are quite a few different common business scenarios where you get data in the form of a file on a regular basis. The 3 common patterns I use most often are. Each day/month/year you get a new…

HAPPY NEW YEAR!! What a year it’s been – full of successes, changes and everything in between. There have been so many amazing communityinfluencers and incredible posts in the Microsoft Power Platf…

As part of the Flow design process, I often end up building in some debug actions like Send email, Set variable etc. to capture/troubleshoot values that in turn help along with the actual design. B…

We’ve got 5 things you might not know about Power BI. These are little things that are great for folks just starting out with Power BI, or maybe you’ve used Power BI for a while and just didn’t know about these little things.

If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this data will need to be transformed (i.e. cleaned and joine…

You have millions of rows of data stored in your data warehouse, you have it accessible and available for business users and report users, but how do you effectively tell a story using all that data? How do you unlock the secrets and the potential your data has? In this session Power BI MVP, Ruth … Continue reading “Webinar 1/8: How to effectively tell a story with your data and Power BI with Ruth Pozuelo Martinez”

Facebook Twitter LinkedIn If you haven’t read Part 1 of this series, I highly recommend that you read that prior to this post. In that previous post, we went over the Left Outer Join and some basics on how Joins / Merge operations work inside Power Query / Power BI where the position of the …

In my previous post I mentioned the Common Data Services. In this post I will look at the CDS in more detail. When starting with the CDS it is easy to create new entities and each entity can be used t…

We discussed how to use PowerApps media control like image control, video control, camera control, barcode scanner, picture control, audio control, microphone control etc.

<p>Introducing the 2019 Power Platform World Tour featuring PowerApps, Microsoft Flow and Power BI content from Microsoft team members, MVPs, Champions, and Subject Matter Experts. Power Platfor…

Happy New Year 2019 to our P3 readers! For the new year, I have a question for you: What do you think of when you hear the word “Flow”? For me, I immediately think of “Flo” from Progressive – someone …

Data lineage is a DAX feature so well-implemented that most developers use it without knowing about its existence. This article describes the data lineage a

Tab Order Enhances Power BI Report Accessibility (@mmarie) What has happened in the DAX world in 2018 (@marcorus) Happy New Year from Power BI Desktop! Power BI Service and Mobile November & December Feature Summary Power BI Roadmap BONUS ITEMS: ArcGIS Maps for Power BI – Further capabilities and other information (@blogenginenet) Interviews from PASS […]

(2019-Jan-06) In the past, I used to always rely on shapefiles crafted by others to create my map visualizations in Microsoft Power platfor...

It’s all the Power BI content you’ve come to expect from Microsoft team members, MVPs, Champions, and Subject Matter experts but this year’s Power Platform World Tour will now include PowerApps and Microsoft Flow content. Power Platform World Tour will bring together thousands of users in cities all around the world to learn and network … Continue reading “The Power BI World Tour is back in 2019 as the Power Platform World Tour!”

A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it ca…

The Q&A feature in Power BI desktop provides a way to move towards Artificial Intelligence. In my previous article, we learned about the prominent Q&A in Power BI Desktop feature. We can get the desir…

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: &#…

This post is going to show an alternative for conditional formatting using lookup. I often get asked how to do conditional formatting or asked to help change existing conditional formatting that is not based on multiple conditions in an IF or SWITCH statement or nested IFs if you haven’t noticed PowerApp IF allows multiple tests. […]

Export data from Power BI to csv -files is best done using Python. Check this article for hows and whys:

Warning This is a less ranty than my first “road to MVP” post.I’m finishing this post at the end of december. And while I know there’s already a 3rd part as well, I found it…

(2018-Dec-31) Back in July of 2018, Ontario provincial government of Canada decided to decrease the number of Toronto city wards from 47 t...

Why Bother?

Happy New Year ! With over 150 features released, 2018 has been a prolific year for Power BI Desktop! To cap off this successful year, our team put together a fun video, showcasing our pick for the…

<p>The team has been busy the last month of 2018 shipping new features and fixes for you. You can view the weekly release information here https://aka.ms/PAWeeklyReleaseNotes . …

Visual Vocab, Power Query Keyboard Shortcuts, Power BI Dataflows and more… Catch the last Power BI roundup for 2018! Merry Christmas, happy holidays and have a great New Year! Financial Times Visual V…