Power BI

Public preview announcement of access rights admin APIs

Third blog in the series on Transform a local into a global Power BI solution. After covering the general differences between small scale and enterprise solutions and last week all about content sh…

There are many, complicated ways to conduct a causal analysis; however, an event study is particularly well suited for a tool like Microsoft’s Power BI. Similar business intelligence software are better known for describing what happened through visualizations rather than why something happened.

Overriding filters that are passed as filters in the tooltip opens new possibilities. This can be done for regular tables but also calculation groups.

Ready for some cool data visualization? In this part, we're building our report in accordance to some of the best data viz practices!

Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? We have just released our 10th app on AppSource that can help you achieve it. Excel Compare (available on AppSource here) is a free Power BI app that compares two Excel files of your choosing and detects differences and errors […]

This video provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the

This session is purely Q&A with Marco Russo on Power BI report optimization and will guide you in analyzing the possible reasons for a slow BI report.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - Planner Reporting Beta Data Stage is a manual install. This is fairly straightforward.

It’s here! Have a look at the Power BI Paginated visual for your Power BI Reports! It adds additional flexibility for displaying data as well as providing easy export options if that’s your jam. Blog Announcement: https://powerbi.microsoft.com/en-us/blog/paginated-report-visual-for-power-bi-reports-is-now-available-in-public-preview/ Documentation: https://docs.microsoft.com/power-bi/visuals/paginated-report-visual BIFOCAL Show Podcast: https://bifocal.show/ Jason Himmelstein’s white paper: https://sharepointlonghorn.com/the-new-paginated-report-visual-is-here/

I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI app that we released on AppSource earlier this week, and you can consider reading this post as a technical challenge to evaluate your Power Query […]

After everything about sharing content and requesting access to content, it is time to talk about discoverability of content in the Power BI Service. The next blog in the series of transforming a l…

You’ve spent time creating Calculation Groups in Power BI only to find that they don’t work. What’s up with that? Patrick may be your only hope. Calculation Groups Documentation: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups

In the final part, we will take our analytics skills to another level! Not just that - based on the insights unlocked, we will recommend certain actions!

Dealing with estimated data often gives you numbers with more precision than you need or trust. Dynamic Rounding can create gains in performance.

Some Power BI report design skills take years to master. These basic visualization concepts are easy to learn and they will make your reports far better.

Easily overcome a potential data source issue when migrating to Power BI Premium.

Since Power BI launched, we have been listening carefully across our different avenues of feedback to what you, our users, need added to the product. Our Ideas site has been the main place for you to leave suggestions. In July 2020 we migrated to a new platform using Dynamics 365 and Power Portals, and we heard from you about issues with the new site. Over the past year, we addressed many of those issues and have recently made a larger update to fix some major problems.

We are excited to announce General Availability (GA) for Single Sign-On (SSO) through the data gateway to cloud data sources that rely on Azure Active Directory (AAD)-based authentication. In addition to Kerberos-based and Security Assertion Markup Language (SAML)-based SSO to on-prem data sources, you can now get seamless AAD SSO connectivity to Azure-based data sources, such as Azure Synapse Analytics (SQL DW), Azure Data Explorer, Snowflake on Azure, and Azure Databricks through an on-premises data gateway.

Today we are thrilled to introduce the newly released Power BI component for Angular. This component lets you easily embed your Power BI reports, dashboards and more into your Angular web application.

Models utilizing XMLA endpoints will reflect refresh details in the Power BI Service!

We are very excited to announce the public preview of a new REST API to query datasets in Power BI by using Data Analysis Expressions (DAX). Among other things, this new DAX REST API helps to address customer feedback concerning programmatic access to the data in a dataset (for example, the idea REST API access to READ datasets with almost 500 votes by the time of this announcement). The new DAX REST API avoids dependencies on Analysis Services client libraries, requires no connection to XMLA endpoints, and works in Power BI Premium as well as in Power BI shared capacity

We are very thrilled to announce the general availability (GA) of Backup and Restore for datasets in Power BI Premium and Premium per User (PPU). Whether you are migrating Azure AS workloads to Power BI or must consolidate Power BI tenants due to a merger or acquisition or simply want to backup Power BI datasets on a regular basis to meet the data retention and disaster recovery requirements of your organization, you can now rely on the Backup and Restore capabilities of Power BI as a fully supported feature.

Stand out from the crowd with an interactive CV built with Power BI. Our BI Consultant, Irene Christina shares this step by step guide.

This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and t

This week the Power BI team announced an awesome new feature. It's the ability to run DAX queries against your Power BI datasets via a REST API. Wow, wow, wow! Given that coding API's might not be something everyone has the ability to do, I thought I'd share how you can use Power Automate to run a DAX query, extract data & save it to a file. Here is a high level summary of the Flow I built: Obtain a Token to authenticate to the Power BI REST APIs Call the new Power BI API, passing a DAX query Pa

Second post in the “Doing Power BI the Right Way” series. In a business intelligence solution, data must be shaped and transformed. Your data is rarely, if ever, going to be in the righ…

Recently I was asked to provide an example of a custom Linear Regression Trendline in Power BI that can dynamically re-calculate for both different levels of a Date hierarchy along with different filter selections. After designing and creating the example, I thought it would be useful to share wit...

In this Power BI tutorial, you'll learn how to build a correlation plot natively in Power BI. Also called a correlation matrix, this plot is helpful to understand how different variables in your data is correlated. Does a positive change in Variable A create a positive change in Variable B? This is easy to plot and understand with a correlation matrix. Check out the video above to learn how to build one yourself without the help of any custom visual or R/Python scripting. ---------------------------------------------------------------------------------------------------------------- To enroll in my introductory or advanced Power BI courses: https://training.bielite.com/ Blog Post/PBIX Download: https://bielite.com/blog/native-correlation-matrix-power-bi/ Cars Dataset Info: https://cran.r-project.org/web/packages/explore/vignettes/explore_mtcars.html Correlation Coefficient Calculation: https://www.statisticshowto.com/probability-and-statistics/correlation-coefficient-formula/ Elite Power BI Consulting: https://bielite.com/ Data Insights Tools: https://www.impktful.com/ Connect with me on Twitter! https://twitter.com/PowerBIElite 0:00 Intro 2:50 Setting Up the Data 5:46 Creating Measures 11:55 Quick Formatting