Power BI

I recently created this simple Power BI desktop file that allows you to try out dynamic security with the new security relationship feature as described in this blog post. The model contains the fo…

PowerBI allows users to add measures to tooltips. Many users want to add text columns as well. Today if you drag a text column to the tooltips, a count measure is created which is not very useful. …

I can hear you yawning already – yet another blog post on getting data from multiple Excel workbooks in Power Query and Power BI. Just about everyone who has ever written a blog post on Power BI ha…

Use DAX and Slicers to create thresholds of sentiment analysis scores and translate values between 0 to 1 to Negative, Neutral and Positive ranks.

On previous blog posts, I have showed you how to create monitoring dashboards for both Google Analytics and Adwords.I use those dashboards myself even though I am not a big fan of monitoring

Introduction Let's face it, our data is not always as clean as we would like it to be. There are many cases where we would like to transform our data into something more friendly to end users or standardize known data issues. For example a customer might be referenced in our data as: Customer Name ...

If you’re a partner with a Data and Analytics practice, now is an ideal time to hone your skills and plan a Power BI campaign for the fall. With Microsoft Power BI, you can help your clients experience their data in new ways, integrate their data and dashboards with Office 365, and deliver a native...

UPDATE: Thanks for attending the Webinar. Webinar Recording:Click to watch the recording on our YouTube Channel Power BI File Download: I am unable to shar

Hi dheeraj_ami,   If your data source has related table about the group type, you could use RELATED function or lookup value function to add the group column. If your data doesn’t exist group column, you could try to use if function or switch function to add the column. (you could refer to my earli...

ExcelRefresh - command line utility to refresh Excel documents and their external connections, query tables and pivot tables.

Okay – so something (actually a few things) have come up at work recently and this caused me to miss my planned SSRS parameterized DAX post. I’ll try to get to this soon as it’s a…

Introduction I was wondering whether I could add predictive analytics into my PowerPivot Workbooks. If I could predict the sales base...

Hi, The attached technical document describes an approach for providing users of Power BI, SSAS Tabular, and Power Pivot models with a  default filter context. Essentially, DAX metrics are filtered…

Hi, As mentioned in last week’s Power BI August Update to the On-Premises Data Gateway I’ve attached a sample of the Power BI Desktop file referenced in the previous post regarding gate…

In general, your formula will be:   = if Duration.Days(DateTime.LocalNow() - [Date])

I create a column with following formula. When you select a year in the slicer, the table will show the active customers in this year and show if this customer will churn in next year. If it is not you wanted, please provide an expected output. ChurnNextYear = IF ( CONTAINS ( Table1, ...

Not quite sure if this is what you're looking for, but I do something similar using LOOKUPVALUE.  Basically I find where USERNAME() matches the Email in the Users table and then filter the Programs table where either the returned Program 1 or Program 2 match.  The filters on the Programs table then ...

A place where APIs are kept.

Check out this data story: Vizion Solutions MLB Analysis #PowerBI #DataStoriesGallery https://t.co/43hhvVO7BA pic.twitter.com/c2py2mGY9C— Lukasz Pawlowski (@lukasztweets) August 25, 2016

Learn how to connect to an Oracle database from SQL Server and Microsoft business intelligence (BI) tools.

With this month’s release of Power BI publisher for Excel, we’ve improved the experience of connecting to Power BI data from Excel, allowing you to connect to data in read-only groups and connect to reports and datasets that were shared with you.

Today we are announcing two features to assist organizations meet their security and compliance requirements as they deploy Power BI. First, Power BI now supports Azure AD Conditional Access to…

Description Forecasting is used to predict next points in time series data sets. The prediction in this example is based on trend and seasonality.     Prerequisites (The sample .pbix files will not work without these prerequites completed) 1. Install R Engine Power BI Desktop does not include, deplo...

Today we are excited to announce the release of the brand and campaign management solution template for Twitter. Now you can analyse sentiment, follow related trending topics, and find your biggest influencers, all in just minutes!

Excel 2016 includes a powerful new set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce eight new data transformation and connectivity features that have been requested by our customers. —Read on for details.