Power BI

In this digital age, data is a strategic asset, and creating a modern data catalog is key to finding and connecting siloed enterprise data, which enables people to ask important questions and gain business insights. Microsoft used feedback from end users to develop an intuitive data catalog that incorporates discoverability, traceability, and access management. To gain adoption for the catalog, the team generated excitement through a structured marketing campaign that used internal social channels, posters and digital signage.

Microsoft’s drive to make more and better data-driven decisions is fueled by analyzing data with Microsoft Power BI.But how is it getting employees to analyze their data and build their own …

This is not the first time I have shared this concept.  In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some [...]Read More »

Today, Forrester has recognized Microsoft as the Leader in both strategy and current offering in The Forrester Wave: Augmented BI Platforms, Q3 2021.

Frustrated that a you can only do a full refresh? Patrick takes it to the next level by showing how you can refresh only a single table in your Power BI dataset. This is a great option for targeted refresh and avoid potential overhead. Processing Options: https://docs.microsoft.com/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services?view=asallproducts-allversions Refresh Types: https://docs.microsoft.com/azure/analysis-services/analysis-services-async-refresh Elegant BI Blog: https://www.elegantbi.com/post/datarefreshintabulareditor https://www.elegantbi.com/post/processingmanager

This article reviews Data Governance Initiatives to determine how to secure data usage, manage activity, gain visibility, and control of one of your most important assets.  Whether on-premises or in the cloud, more employees are using and sharing an ever-increasing amount of data throughout your organization.

Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance an

Power BI Push Tools is a set of open-source tools to work with Power BI push datasets. Read Implementing real-time updates in Power BI using push datasets i

Download your Free Power BI resources

Tables in your Power BI reports don't need to be old-fashioned boring visuals. Check how you can create astonishing tables for your users!

Have you ever been faced with the issue where Power BI automatically adds a sigma symbol to the front of your column if it detects it’s a data type of integer or decimal? Now this isn’t too much of an issue if you’ve imported only a few columns but what if you’ve imported lots? Going […]

Video by: Reid Havens Learn a unique way to utilize a waterfall by restricting its categorical comparison to just two values , with a breakdown comparison between. By combining a slicer and a bit of DAX magic in Power BI.

Embed Power BI Goals in your app With data flowing from every corner of an organization, it is easy to get lost in a sea of information where key data points are sprinkled across scattered reports and dashboards. Goals is a new Power BI feature that helps individuals, teams, and organizations keep t...

Modify the formula of an article answering a reader question: How to compute the last 6 months of transactions using the last transaction date of each custo

This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. The CONTAINS function in DAX h

Using OKRs today or want to learn how to use Objectives and Key Results using Power BI Goals? This post will show you how to support OKRs.

Data mapping with table connected to the dataset streamlines the process of data mapping to ensure all values are mapped with minimal effort.

You probably know that it’s a best practice to build your Power BI datasets in a separate .pbix file from your reports – among other things it means that different people can develop th…

Welcome to the August 2021 update, can you believe that it’s August already?! In this update we have exciting new things for Q&A as well as for Shapes. Also, new this month is Automatic aggregations for DirectQuery. There is more to explore, please continue to read on.

We often have our data spread out in different Excel workbooks and sheets. How do we combine all of them into one table? Let’s walk through an example. We have our data saved in a folder with three files: 2019.xlsx, 2020.xlsx, and 2021.xlsx. You can download the files here. Each file contains three sheets: AC, …

Have you ever wondered why a Power BI dataset refresh was taking so long? And more specifically, how much time did the refresh spend on various sub-tasks that aren’t that visible to you via the …

I’m pulling data from GitHub Codeowners into a Power BI report. All was dandy locally, but refresh failed on the PBI service with this:This dataset includes a dynamic data source. Since dynamic data sources aren’t

A new look for the Power BI in-product store coming with August release!  In the store you can browse all the visuals authorized by your organization.

A full, easy to install Power BI Version Control solution allowing source control, check ins and local editing. Download for free now!

We are excited to announce that the Power Query forum is now available in both Power BI and Power Apps communities!

was listening to this Excellent Podcast about Minerva, basically Airbnb went and built a Metrics Store which is a central tool that hold all Measures and dimensions, the idea is to have one source …