Power BI

Adam looks at the different sharing and collaboration items within Power BI. From the share button to apps and embedding options. Power BI offers many options.

Patrick looks at a customer scenario where he found Power BI tooltips causing report performance issues. He shows how to identify and then a possible solution.

As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about data privacy and what data is getting shared by those visuals? If you have sensitive data in …

The weekly Power BI RoundUp from FourMoo talks about the Python visuals, Power BI Premium White paper and tailoring help when usiing Power BI

To ensure employee productivity and satisfaction with Power BI, enterprise organizations develop comprehensive product training, bolster their help desks, and invest in helping their user communities with internal forums to share ideas and best practices. But it can be a challenge to educate users about the availability of these organizational resources. The exciting news is … Continue reading “Tailoring help and support for Power BI users”

Charticulator is the first item that I mention in my recent Power BI Best of 2018 in Data Visualization post. It’s an exciting new tool from Microsoft Research to quickly build advanced visua…

Power Query has a lot of built in functions, but it doesn’t have a function that exactly matches the VLOOKUP in Excel – but by using the M language and other M functions we can certainly repl…

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date colu…

This article discusses a few little-known facts about the Sort by Column feature of Power BI.

A new whitepaper authored by Peter Myers presents a comprehensive body of knowledge covering all aspects of deploying, scaling, troubleshooting and managing a Power BI Premium deployment in an enterprise. The whitepaper provides both background information explaiing how various Power BI concepts play together in an enterprise deployment as well as practical examples of challenges encountered in … Continue reading “Power BI Premium Deployment and Management Whitepaper added!”

Understand the potential of Power BI Premium, and learn how to design, deploy, monitor and troubleshoot scalable solutions.

Patrick walks you through how to use a Power BI quick measure and then easily modify it. In this example, he uses the concatenated list of values quick measure in Power BI Desktop.

This blog post will present a set of custom controls built using the new PowerApps component feature for Canvas apps. As a prerequisite, check out Yifie Wang’s blog post introducing the PowerApps components feature and Brian Dang’s “start your journey with components” blog post that includes instructions on importing/exporting components and more. Before we delve … Continue reading “10 Reusable Components: tab control, calendar, dialog box, map control and more”

I’m not dead! After having a prolific first few months with this blog, the year-end holidays disrupted my routine, and I’ve been struggling to get everything balanced again. 2019 has be…

Makers can now quickly and easily edit the filters for their model-driven views. The view designer displays filters in the Filter by … section in the property pane. Clicking on the individual filters in the property pane shows a dialog that allows makers to quickly update the operator and the value.

This blog post details how to refresh one table in a Power BI Data Model. Allowing a user to quickly refresh their required data.

Business Problem: In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page. The client had been maintaining a table of KeyPhrases that correspond with Categories. If the Visitor’s landing page contained the KeyPhrase, we wanted to match it

Reading Time: 3 minutes One of the new features that Microsoft announced in February’s Power BI Desktop update is the Improved Python & R Script Editor. The script editor now contains the same features as the DAX editor, including IntelliSense for code completion. After spending some time with the new editor though, I made a discovery about the code completion.…

With our February update of Power BI, you can now share, publish and view Python visuals in your reports and dashboards. This update extends the support for Python in the Power BI Desktop to the Power BI service. This ability completes the support for Python in Power BI, enabling you to use Python scripts to … Continue reading “Python visualizations in Power BI Service”

In my first month of joining Microsoft, Emma Cooper, a Program Manager on the PowerApps team, knocked on my door with a shine of delight in her eyes. “You can copy and paste controls from one tab to another. Do you want to try it out?” Emma knew my answer without me needing to say … Continue reading “Components: Start your Journey with Reusable Controls”

Thanks for watching this week’s Power BI news roundup! Last weeks roundup 2 Minute Tuesday Patrick’s tech video Adam’s tech video Sources Show Me the Biggest Number! Conditional Formatting in Power BI (@Rad_Reza) Creating Report Tooltips in Power BI (@HavensConsulti1) Displaying filter context in Power BI Tooltips (@marcorus) Insights made easy with Power BI Template […]

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Reading Prathy Kamasani’s excellent blog post on Sync Slicers the other week I had a revelation: in the post Prathy shows how it is possible to sync selections between two slicers that are based on di…

In today's blog post, I share the generic solutions for the Fill Down challenge that I posted here. As you recall, we had a table of backlog items with three levels of hierarchies (Scenario, Feature a…

Office 365 now gives you the ability to create a dedicated room booking app from one of its PowerApp templates. Its very easy to setup and makes it easier for e

How to hide and show bookmarks based on values in your data

I recently discovered something accidentally in Power BI that might be useful. My colleague Mihaly found a similar technique by accident too a day or so before, so I thought I’d share what we…