Power BI

A common questions I get is to change the connection string to from my report to SSAS after I move my Power BI desktop file into SSAS. It turns out this actually pretty simple as there is an API th…

In the latest update of Power BI Desktop, there now is the capability to be able to use Bookmarks. What bookmarks does is allow you to create an informative way in which you can tell your story. It…

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle…

The Challenge At a recent Columbus Azure ML and Power BI User Group (CAMLPUG) meeting, a member came forward with the following problem around tracking training attendance. Essentially, given a set of…

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis. I've created many videos over at Enterprise DNA TV which showcase these techn…

Last week, we announced the very first version of Power BI Helper. Power BI Helper is a tool that helps clean up a Power BI solution. This week we have an updated version with a new interesting featur…

There are two licensing options for Power BI: Power BI Pro and Power BI Premium. This provides the flexibility to select the model that best meets the needs of individual users and entire organization…

In this blog post I am going to demonstrate how to achieve Pagination in Power BI reports, using the new Bookmarking feature. I got this question from a follower on Twitter Murali Brishna With the …

Workaround for some missing basic Power BI functionality: Right aligning text and dealing with mixed number formats within one column.

In this video, Patrick shows how you can use bookmarks and selections to create interesting reports to show different aspects of your data. He also shows a very cool way to change between those select…

Today, we’re pleased to announce the release of a new version of Power BI Report Server. This release contains all of the features we first introduced in the August 2017 Preview, and several new featu…

Free – Buy Now Checkout Added to cart

This report uses the Power BI Licensing options to demonstrate how user entries can be applied to calculate different scenarios. I did not have the model used for the actual calculator, but I think I …

So many people on the Power BI team at Microsoft have been working day and night for the last two years making the Power BI platform and its constantly-evolving feature set more competitive against Ta…

With all the recent updates and announcements from SQL Pass, as well as the Power BI World Tour. And there is a lot of great things to look forward to coming in the next few months! Please understa…

I have written while ago, about how to implement a dynamic row level security in Power BI. This post is an addition to that post. I’ve had a lot of inquiries that; “What If I want users to see their o…

You can get seamless single sign-on connectivity, enabling Power BI reports and dashboards to update from on-premises data, by configuring your on-premises data gateway with Kerberos. The On-premises …

This month conditional formatting gets a major update with the ability to control the color based on rules. If you have a slow data source, we now have report options that help limit the number of que…

In the November 2017 release of Power BI Desktop one feature got my attention: Query Reduction for Direct Query Models. In some cases, sources for Direct Query models are either large (and therefore n…

The Dynamic RLS topic is getting a good response in my blog post, so I intend to write about other types of scenarios that a security would be required. In this post, we are going to look at another t…

Today, I found out about a Power BI Q&A feature that enables you to customize the visual appearance of your Q&A results. Treb Gatte shows this feature in a short video, but I would also like to presen…

The film executive hired private investigators, including ex-Mossad agents, to track actresses and journalists.

The Power BI team recently added additional map styles for the Map and Filled Map that make them a m...

With the October release of Power BI Desktop, users have the ability to leverage 2 really cool featu...

If you are the goto person for Power BI in your organisation, then I am sure at least once you may h...

Power BI’s default connection type is Import. In fact, if you have never dealt with a data source th...

The more you work with Power BI Desktop it is more than likely you will find some tool limitations t...

In this video, Adam looks at how to use conditional columns within Power Query and then copying them...