Power BI

Recently, I created a NBA shot chart in Power BI as part of my entry to the Microsoft Power BI Best report contest and I had got a lot of questions on how I made the visual. So I decided to write a

Introduction I'm not happy with the solution presented in my former post about Daily sales report  because the current month is determined...

Introduction  In this blog post I would like show you step-by-step how to build a report in PowerPivot with DAX expressions. For my curren...

Hello, I have a quick question. I am trying to calculate the $ Change (YOY) for a sub category, and then trying to compare that overall sub category change to specific products. Basically, we want to find products that are underperforming a sub category, but by using dynamic comparison. Here is the ...

A place where APIs are kept.

Source File Details: To demonstrate this concept, we have created an excel file with dummy data and connected it to Power BI Desktop Tool. In the

PowerPivot is a wonderful product, but its editor is its weakest point: Making expressions easy to read is difficult! This blog shows how to download and get started with DAX Studio, a separate Excel

The newly released DAX studio is an excellent tool to develop and troubleshoot DAX calculations as it provides a way to visualize tables as they are internally represented during the computation. The

Yesterday was a terrific day for all of Microsoft Power BI fans. Microsoft released updates for Power BI Service, Power BI Mobile and Power BI Desktop (with an unbelievable 44 new features)

In the 2015 September update, Power BI introduced calculated tables, which are computed using DAX expressions instead of being loaded from a data source. This article shows the usage of calculated

If you are a person who creates data models or builds Excel workbooks that will be used with Power BI, read on... In Power BI, Q&A can search structured data and choose the right visualization for your question -- that's what makes it a compelling tool to use.

Today we are releasing another massive update with lots of new capabilities that will be exciting for many of our customers, spanning from Power BI Desktop to the Power BI service. This update includes several new Report Authoring features as part of...

Power BI and iFrame are working very nice together now. In this post you learn how to embed Power BI reports in your website or blog.

YoY% = var Sales = [Sum of SalesAmount]var SalesLastYear=CALCULATE([Sum of SalesAmount], SAMEPERIODLASTYEAR(‘Calendar'[Date]))return if(Sales, DIVIDE(Sales – SalesLastYear, Sales))

Seats are filling up for fast for the Microsoft Data Insights Summit, happening March 22-23 in Bellevue, Washington. We

A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action in Power BI. This has been something that customers have been clamoring for but now its fin…

Thank you to everyone that attended my Power BI webinar last month, September 29th. Sorry its taken me a while to finally make the information available, but my schedule has been crazy lately! The …

Microsoft

The new Power BI experience simplifies sharing and collaborating on data that will excite your users and simplify management for administrators. For organizations that already use Power BI for Office 365, find out how to migrate your users and data to the new experience.

If you are like me, you have probably stared at a white page wondering what your next topic should be on your blog or what additional content could be relevant for my site. I have written about the

Power BI has two data gateways, Personal and Enterprise. Since I assist companies with Power BI, the name Personal Gateway made no sense to me, especially when I used a personal gateway to update an

I Bet You Think This is a Picture, Don

Our goal with Power BI has always been to enable users everywhere to experience data and bring it to life in the best way possible. With the General Availability (GA) of Power BI last year, we took a

Microsoft's Power BI data visualization service is making it possible for companies to share their business information with the world in an interactive format.

In SQLSaturday Paris I made a demo of Real-Time twitter analytics in PowerBI using the PowerShell module PowerBIPS. In this post I will show how I did that (you can find the full script at the

With Power BI gateways, you can keep your data fresh by connecting to on-premises data sources. The gateways provide the flexibility you need to meet individual needs, and the needs of your