Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

«February 2016»

Power BI Publish to Web for Anonymous Access is Here

Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web” as a preview feature. This is HUUUUGE news! This was probably the top requested feature and its finally here thanks to the hard work and dedication of the Microsoft Power BI team!

Read Getting Started with R Visuals in Power BI

Power BI “publish to web” allows you to easily expose a Power BI report to the world through an iframe that can be embedded wherever you like.

To publish your Power BI report to the web, log into your Power BI site.

Find the report that you want to share and click File in the top left.
Power BI publish to web

You’ll see a message pop up box similar to below. Click the yellow button to create the embed code.
Power BI publish to web preview

This is where you’ll see a very important warning!
WARNING: Reports that you expose through the “publish to web” feature will be visible to everyone on the internet! This means NO AUTHENTICATION is required to view the report that is embedded in your application.
warning 2

Once you do that, you’ll receive an embed code that you can then use to expose your Power BI report within your blog as seen below!

As you can see the report maintains all the interactivity features of Power BI. And as your Power BI report updates and changes, those changes will be reflected in your embedded Power BI reports!

Pretty awesome!

Additional Resources

Read the Power BI “publish to web” announcement here.

Read the Power BI “publish to web” documentation here.


Let me know what you think of this feature or if you have any questions. Leave a comment down below.

Read more


Non Empty vs NonEmpty

Hey everyone, in this blog I want to address a very common MDX Question. What is the difference between the NON EMPTY keyword and NONEMPTY function? To take it a step further which one should you use?

Non Empty keyword VS NONEMPTY Function.

The big difference between the NON EMPTY keyword and the NONEMPTY function is when the evaluation occurs in the MDX. The NON EMPTY keyword is the last thing that is evaluated, in other words after all axes have been evaluated then the NON EMPTY keyword is executed to remove any empty space from the final result set. The NONEMPTY function is evaluated when the specific axis is evaluated.

Should I use NON EMPTY keyword or NONEMPTY function?

Ok Mitchell, so you told me when each of these are evaluated but really you haven’t told me anything up until this point. Can you tell me which one I should use already? Well, unfortunately, it depends. Let’s walk through an example of each using the BOTTOMCOUNT function.


In this example I’m returning the bottom ten selling products for internet sales. Notice that I have returned all products that have no internet sales, this is not necessarily a bad thing, maybe you want to return products that don’t have sales.


However if you don’t want to return these products then we can try using the NON EMPTY keyword. In the below example you can see the results when I add NON EMPTY to the ROWS axis.


WHOOOAAA, what happened?? A lot of people would have expected the results here to show the bottom ten products that DID have sales. However, that is not the case, remember that I said the NON EMPTY keyword is evaluated LAST after all axes have been evaluated. This means that first the bottom ten selling products which have $0 in sales are first returned and then the NON EMPTY keyword removes all that empty space from the final result.

BOTTOMCOUNT function with NONEMPTY function.

So let’s try this again, if you want to return the bottom ten products that had sales then we must first remove the empty space before using the BottomCount function. Take a look at the code below:


In this code we first remove the empty space before using the BOTTOMCOUNT function. The result is we return the bottom ten products that had internet sales. Once again neither one is right or wrong here it just depends on what you want in your final result.

NON EMPTY Keyword vs. NONEMPTY Function – Performance

There is a very common misconception that the NONEM

Read more

Power BI Q&A Preview Now Live On Your Data

  • 18 December 2013
  • Author: DevinKnight
  • Number of views: 4263

With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick tutorial of how it all works.  This post will walk you through uploading a workbook to Power BI, Using Q&A against that workbook, enhancing the workbook with synonyms and the creating features questions.

First, sign up for a trial at  Once your trial Power BI site has been issued to you login and add your own Power Pivot workbook by selecting Add as shown below.


After you add your own workbook click the context menu and select Add to Q&A.


Next select Search with Power BI Q&A in the top right corner of the site.


This will present you with an empty textbox that is waiting for you to ask a question of your data.  Earlier when I added my own workbook I added a workbook that has presidential election data in it.  So I ask a question about the “Total popular votes by state”. 


With this small amount of information I provide Q&A realizes I’m asking for the Total Popular Vote metric from my Power Pivot model and that I want to see this information by state, which is also in my Power Pivot model. 


A couple other interesting things are presented here.  In the top right there are some hints on getting better search results for this workbook.  If you follow the help link there is some guidance on adding synonyms to your Power Pivot model:

I wrote briefly about synonyms being added to Power Pivot as well here.  Adding synonyms will allow my users to have more flexibility when interacting with Q&A.  Currently without synonyms in my model I must ask very specific question that reference column names exactly how they appear in my Power Pivot model. 

However, with synonyms added to my model I could add other variations of how users may ask my question of “Total popular votes by state”. 

Below I’ve added a synonym to my model on to Total Popular Vote metric.  Synonyms are entered with a comma separated list so I’ve added “votes” as a synonym for Total Popular Vote.


After publishing this workbook back to the Power BI site I can now ask the question more like an end user would.  This time I ask for “votes by state” and get the same results as expected.  This shows how you will start designing your Power Pivot models that you plan on publishing within Q&A.


The last nice new feature that is available in the Power BI Q&A preview is featured questions.  Featured questions are inquires that you would like to highlight on the Power BI site as common questions users ask.  These were in the preview before but you could not create your own. 

To create a featured question you simply click add featured question on the side pane or before you even ask a question click the plus icon (both shown below).

image image

Once you select one of these two options you enter the question and create an icon.  The icon can be small or large, a variety of colors, and with a symbol or even a background image.


Here’s an example of a featured question I created for this election data model.


I really love these new features and I think you will too so go try them out now at

Rate this article:
No rating


Other posts by DevinKnight

Please login or register to post comments.