Power BI

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.

Accordion UI Control Canvas Apps Component Often we need to show more relevant data with respect to a record without impacting user navigation experience & achieving the simplicity. For such need in Canvas apps, where we need to show the Record's 360 view - this component will help to show the 1...

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…

Data flows in Azure Data Factory and Azure Synapse Analytics now support REST endpoints as both a source and sink with full support for both JSON and XML payloads.   You can now connect to REST endpoints natively in ADF & Synapse data flows as a way to transform and process data inline with the code...

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

Calling all creators! Back in August 2016 we introduced predefined matrix and table styles. We are exploring adding more predefined styles to more visual types to save you precious report creation time. We have created this survey to gather your feedback and help us define what these styles should look like.

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 …

Hello! It’s me, Maya (you can find me on Linkedin here). As usual, I bear with me exciting news: we have just published a new, super-useful update of the Power BI Custom Visuals Exploration Tool. The Power BI Custom Visuals Exploration Tool (install it here) connects directly to AppSource to present all the publicly available […]

A couple of months ago, we launched a new Power BI integration for visualizing SharePoint lists for all Targeted release users. We’re now excited to announce that the experience has rolled out to Standard release users and is now accessible to everyone!

Often when we set up a Business Application based on a Dataverse database, we are asked to make data available for reporting purposes or simply to feed a third-party database that will be consumed …

Azure Synapse Link (earlier known as Export to Data Lake Service) provides seamless integration of DataVerse with Azure Synapse Analytics, thus making it easy for users to do ad-hoc analysis using …

Model-driven apps and Microsoft Dataverse diagnostics and performance data can be monitored in an Azure Application Insights resource. On a high level, you can report user activity with specific forms and it will allow product owners to understand adoption blockers and drivers.