Power BI

We have a large dataset of unstructured data (Azure Blob) and have started noticing that refreshing our model gets quite slow after a few thousand records are being loaded.   Our current query structure is: #"Load Data" Loads data from the Azure Blob, ~1000 files Parses the files into a ta...

If...Then...Else in a Custom Column We have all used an "if...then...else" statement, when adding a custom column in Power BI query (using Excel Power Query, or Power BI Get Data). Here is a quick example from our book, Chapter 20 "Power Query to the Rescue", Scenario #3 – Adding Custom Columns to...

Microsoft’s Power BI team has put together a tutorial on a proposed approach for visualizing the output of an Azure Machine Learning model inside Power BI. A blog post invites users to “imagine if you could have Power BI regularly bring in the latest output of your fraud model or the sentiment for recent Tweets...

We hope you are enjoying using Quick Insights on your dashboards, and we are happy to announce that Quick Insights scoped to a single tile just got a whole lot smarter. This is a great feature for…

Usability Can your data model (Power Pivot or Power BI) easily be used by 100s of users? Is your model fairly intuitive to understand for the end-user even

This month we are adding some hotly requested features to Power BI Desktop including customizable tooltips, conditional formatting in tables, quick calculations and new connectors.

Two of the new features in the Power BI Desktop April Update are Query Parameters and Power BI Template files. In this blog post, we will take a deeper look at the new capabilities and scenarios that these two features enable in Power BI.

We have heard your feedback and we are pleased to announce that you can now upload files to Power BI up to 1 GB in size. We also have several more improvements to our RLS and Analyze in Excel previews and a brand new feature: Favorite Dashboards.

Today we’re happy to announce the public preview of solution templates for Power BI. This project is launching with two templates: a sales management solution template for Dynamics CRM and a sales management solution template for Salesforce.

Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and the relational data modeling, there is the expectation that you can do the

Introduction Neither Power Query nor DAX supports Excel functions for performing alternative number base conversions to decimal, such as HEX2DEC. Solving this issue in Power Query or DAX becomes problematic due to the lack of traditional looping capabilities within these languages. However, custom f...

Bring your data to life with the Karabina Power BI Masterclass

Cool question - using the query editory you can sort the table and add an index so that each row has a distinct number (0,1,2,3, etc).  Here's the formula you want to write ... I broke it out into pieces.   Total = SUM(Total) Total - Previous Period = VAR thisperiod = MAX(Index) RETURN CALCULATE ([...

To the best of my knowledge, queries do not update their dependencies, would make a nice Idea though. You might consider digging into the Advanced Editor and finding a way to combine your queries into a single query. I have a blog article on this "Power BI: Merge Queries with M". You should be able ...

You can use a  calculate table or can create aformula similar like this one     Calculated table formula:   NewTable = ADDCOLUMNS ( SUMMARIZE ( Sales; Sales[ClientID]; Sales[Amount] ); "Last Date"; CALCULATE ( MAX ( Sales[Date] ) ) )  The formula assumes that for the same date the client has...

this works as a Measure and you actually don't need the FILTER funciton (I was filtering out Names) Measure = CONCATENATEX ( VALUES ( Table2[Name] ), Table2[Name], ", " )   In a Table Visualization turn off the Totals as in the picture Otherwise Total row will concatenate ALL names

Can a Power BI report be a work of art? It is if it was created by Power BI Community member Miguel Myers. Miguel, is a Data Scientist as well as a Graphic Designer, and in a webinar last week he shared some of his tips for creating reports and dashboards that are as beautiful as they are informative. Watch the webinar in its entirety on-demand, or read on for a few highlights!

Power BI Synonyms is a great feature. In this post you learn how to add synonyms to a Power BI Desktop model and how they affect your Q&A query experience.

Today we are thrilled to share a collaboration with Narrative Science and a new custom visual: Narratives for Power BI, which automatically communicates insights from all connected Power BI data sources -- in natural language.

The marketing analytics report represent an example of a Power BI report provided as part of a marketing analytics solution.  This solution helps you unify your data, enirch it with third-party data, and unlock the insights it contains.  That enables you to take smart action. The solution shatters d...

This Power BI solution show cases a powerful self-service Sales Dashboard for a famous retail store.   The dashboard consists of following 5 reports:   1. Current Month Performance - A view of KPIs for the current month and for tracking the progress towards target achievement. 2. Historical Performa...

#PowerQuery #PowerBI #dataviz