Power BI

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.

Earlier this year, we wrote about how to leverage the Power BI REST APIs to create real-time dashboards in Power BI. Ever since, we’ve seen thousands of Power BI users engage with our real-time capabilities. As a result, today I am happy to announce the preview availability of a suite of features which make it even easier to stream real-time data to Power BI, and to see that data light up in your dashboards. Designed for easy setup, these new features show our commitment towards allowing our users to quickly gain insights from data of all shapes, sizes and velocities.

In the last few months we have added a lot of R capability to Power BI, with advanced analytics visualizations with R, data cleansing with R, and ways to get data with R. Customers and partners have told us about some amazing use cases that leverage these capabilities and add unique value. In order to demonstrate these use cases, we have created the Power BI Community R Showcase.

As discussed in my post about Sharing and Security in Power BI, a group workspace in Power BI is our best option currently for organizing content by subject area, and/or by security boundaries.  Members in a group workspace may be allowed to edit content, or restricted to view content (this