Power BI

After the announcement of the Azure Purview preview, the first videos published (Microsoft Mechanics and Simon Whiteley), my first Purview overview blog post it is now time to start with Azure Purv…

With the introduction of the Power BI Premium per User licensing, it can be observed that most small to medium organizations have become excited about it more than anyone. The main reason for this …

These are the seventeen reasons why IT will not let me send my 250MB Excel file that we use to run the business via email At Ricoh Digital Services (AKA the day job) we do a lot of Data & Analy…

The most exciting feature of this version is that now with a few clicks you can clean up the Power BI model, but we have a few other things to add also; Exporting the result of DMV Partitions (Includes the M script of each table)Showing unused measures in the visualization tabshowing all columns/measures that their…

We’re starting off the first full week of December with a bang!  First, we finished rolling out the public preview of Premium per user to all public tenants earlier today.  And now, as if you needed another reason to jump into the preview, we’re pleased to announce one of the most highly requested features on Power BI user voice is now available.

Today’s announcements give a roadmap update for workspace upgrade, content pack deprecation, and announce new tools for Power BI Admins to upgrading classic workspaces through the admin portal. Announcements: Workspace upgrade has reached general availability. We’ve started to roll-out tools for Power BI admins to upgrade classic workspaces. We’re providing a roadmap update below including dates for removing the ability to create, update, and use content packs in classic workspaces.

Two years ago, I published a survey to measure the impact of Power Query. Since then, Power BI has gained tremendous momentum and accelerated the evolution of Power Query as well. I think it's a good time to run the survey again and learn how the impact of Power Query has been changed. Please complete…

Working with the field list on a large model in Power BI Desktop can quickly make you end up with a lot of expanded tables and you collapsing them one by one. Don’t do that Even though that i…

Data Governance – the knowledge, management and insights about and over your data estate is a very important topic. In the past years the number of data stores, systems and data interfaces gr…

Get data from a Power BI dataset is creating a live connection, which is the recommended way, because you will get the entire model. However, sometimes you want to import the data from the model so that you can add other things to it (like another data source). The ability to have a composite model…

Power BI has partnered with the newly released Azure Purview to provide enhanced governance and cataloging capabilities for our customers. The Azure Purview/Power BI integration makes it possible for you to discover and govern all your hybrid data, and thereby gain a more complete understanding of your data.

Today, Microsoft announced the general availability of Azure Synapse Analytics and the preview of Azure Purview, a unified data governance service. Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics.

Announcing a new capability that enables template app publishers to automate the configuration of a template app installation for their customers!

[vc_row][vc_column width="1/1"][vc_single_image media="87976" media_width_percent="100"][vc_column_text]The above video walks you through how to compare two categories against each other in Power BI! […]

When you connect to a Power BI Dataset from Power BI desktop you might have noticed that you can see and use hidden measures and columns in the dataset. But the hidden fields cannot be seen if you …

We have some bug fixes and small features that make a big improvement in using Power BI Helper. In this post, you will learn about the new features added in Power BI Helper in November 2020 edition. in a nutshell, here are updates; layout for different sizes of screensplitters for a better UIcross-filtering workspaces to…

This blog post shows how to vary the partition configuration for Power BI datasets using Power BI Premium or Power BI Premium Per User

We’ve looked at images from sources like OneDrive and the web with your Power BI reports. What about from a database? Is that possible? Patrick takes a look at how you can do it. SQLJason Blog: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html Gerhard’s Blog: https://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/ Chris Webb’s Blog: https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

We’re happy to introduce new admin settings in Power BI admin portal, which provide you more granular control over export options in Power BI, and extend export settings to control also export from paginated reports.

My favourite feature in the October 2020 release of Power BI is undoubtedly dynamic M parameters. However, before I explain why, I’m going to put my hands up and admit that we screwed up the …

When sharing Dashboards, Reports and Apps with External Power BI Users there is an updated view and a way to enable the navigation pane!

Level: Intermediate Updated: 10 Nov 2020 I first wrote this article about how to get tabular data from the Power BI Service into Excel back in Jan 2017. The benefits of extracting tabular data are still the same as they were back then however the process of extracting the tabular data [...]

A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in

Back in May, we released a public preview of a new personalize visuals experience. With this new capability, you can empower your end-users to explore and personalize visuals all within the consumption view of a report. For example, your end-user can change a measure, a dimension, or the visualization itself. Now this month, we are excited to announce that the feature is now generally available!

Power BI Publish to web helps organizations share data on public websites, enabling communities to stay informed. Learn how you can make your reports load faster for users, and provide improved experiences in the event your report experiences heavy usage.

Until now, I have not been very successful with building a perfect KPI visual that would meet my criteria of being able to show the three critical data points that define a KPI for me: Actual Value…

Wanted to record a quick video to: congratulate the Power BI team with delivering of this killer featuredo a quick test drive of anomaly detection and see how I like itprovide a quick overview of w…

I am involved with a Power BI development in the past few days. I got some data exported from various systems in different formats, including Excel, CSV and OData. The CSV files are data export dumps from an ERP system. Working with ERP systems can be very time consuming, especially when you don’t have access … Continue reading A Power Query Custom Function to Rename all Columns at Once in a Table

We have added lots of new capabilities to Power Query Online & Dataflows. This blog post provides a recap walkthrough of these new capabilities.