Last time, we gave you the best case scenario for Q&A against a "raw" data import. However, in order to successfully understand the large swath of questions it is capable of interpreting, Q&A makes a number of fundamental assumptions...

We’ve heard from customers that SharePoint Online is a critical part of their company’s data communication and dissemination strategy and that to-date it wasn’t easy to include Power BI content there. The feature we’re announcing today changes all that.

This post is part of a series about specifications, requirements, work items and test-cases in the field of Business Intelligence solutions. First part is about why I hate and I’d not recomme…

Asking Q&A Questions relating to dates or times   The one thing that I think a lot of people do not realize that Q&A is aware of dates and times.   And by that I mean that Q&A knows when you mean today, it is today’s current date.   It’s always easiest to show with an example.      As you can see a...

Q&A (Natural Query Language) is by far one of the features that I find really gives the WOW factor when showing people the capabilities of Power BI. And in my opinion it is awesome. So I though…

In the June update of the Power BI Desktop there were some really cool features that were added.  I’d encourage you to review the full Power BI blog to see all the June updates.  My favorite of all…

NOTE: If you are the owner of a dataset, add phrasings and synonyms to improve the Q&A results for your customers.Aggregates: total, sum, amount, number, quantity, count, average, most, least, few...

Past releases in power bi have seen new enterprise related capabilities coming out which lets you manage power bi usage within your organisation. Few such feature that came out with Power BI desktop April update is query parameters and template files. In this blog post we will look at how to utilise...

Microsoft today announced that Power BI Embedded will be generally available on July 11, 2016. Power BI Embedded allows application developers to embed fully interactive reports and visualizations in customer-facing apps without the time and expense of having to build their own controls from the ground-up. Microsoft also announced that Power BI publish to web […]

When developing dashboards and reports for a large group of business users you want to make sure you deploy the right content at the right time. In this article we will look at an approach that all…

Update: My Power BI architecture diagram v3 is now available! Head over to here get the latest version! I finally finished putting together version 2 of my Power BI architecture diagram. I previous…

A recurring theme with customers and partners is Power BI data refresh. More specifically, there is some confusion on what refresh scenario requires a Pro version and what can be done with the Free…

I’ve blogged a few times now about how to monitor Power BI query execution times, most recently here, and while using functions like DateTime.FixedLocalNow() is all very well I’ve never been happy …

Do you want to connect to a Power BI Desktop Model from Excel or SSMS? Do you have Power BI Performance issues? Then this article is for you.

One of the things that has intrigued me in the Power Query docs for a while now is the Expression.Evaluate() function, which takes some text and evaluates it as a Power Query expression (rather lik…

If you’re interested in performance-tuning a Power Query query, you’re going to need a reliable way of telling how long your query takes to run. It’s not as easy as it seems to adapt your query to …

What if I told you, there was one key skill, that has set me head and shoulders above the Excel crowd when working with Power Pivot and Power BI? Would you

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.

Power BI and R – Part 1 (Intro) http://blog.janmulkens.be/power-bi-and-r-part-1-intro/