Dynamic Power BI reports using Parameters

In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh.

Install and configure Power BI Report Server (May 2017 Preview)

In this video, I look at how to install and configure the May 2017 Preview of Power BI Report Server. Power BI Report Server has a new standalone install experience and this product allows for Power BI reports to be rendered in the web portal along with paginated reports. This will get you started with [...]

Power BI Premium, Apps and Report Server

So many announcements for Power BI this week! Also, it is Star Wars day!!! May the 4th be with you! Power BI Desktop May Feature Summary Microsoft accelerates modern BI adoption with Power BI Premium Power BI Premium Calculator Power BI initial SKU and pricing information Power BI Premium webinar (May 11th) Distribute to large [...]

Using Apps and App Workspaces in Power BI

In this video, I introduce you to Apps and App Workspaces within Power BI. Apps are a new concept in Power BI and I dive into how to create, manage and use Apps. I will also touch on how Power BI Premium fits into the App story. Learn more about Apps and App Workspaces - [...]

Better use of colors in Power BI

In this video, Chuck Sterling (@chass) is our guest, and he talks about color themes within Power BI. He looks at how you can quickly create your own themes to use within Power BI, or use the theme gallery on the communities site to get pre-created themes from others. Color Theme Generator from Powerbi.tips Thememaster500 [...]

Adam & Patrick Unplugged – April 2017 [EP2]

In this video, Patrick and I talk about what is on our minds. We take a look at some updates in Analysis Services 2017 CTP 2.0. We look at the new navigation experience in Power BI that is coming out in early May. We also talk about some friends, Santa Clause and Power BI reports [...]

DirectQuery, Power BI Datasets and Analysis Services 2017

Using and optimizing DirectQuery in #powerbi and #ssas #tabular (@marcorus) The Must Have Resource list to Master Power BI (@theexcelclub) What’s new in SQL Server 2017 CTP 2.0 for Analysis Services How Microsoft uses Power BI to run its growing cloud business Connecting to datasets in the Power BI service from Desktop BONUS ITEMS: Over [...]

Dynamic Filtering with Power BI and Analysis Services

In this video, Patrick answers your question about how to do this in Analysis Services Tabular and Multidimensional. Also, he adds a little bit of SQL to the mix. Make sure to watch the previous dynamic filtering videos to understand the basics of how to do this. To begin, you need to make sure to [...]

DAX, Maps and Power BI Features

The DAX Unichar() Function And How To Use It In Measures For Data Visualisation (@technitrain) ArcGIS Map in Power BI; Simple, But Insightful (@Rad_Reza) Create Column From Examples (@kpuls) Power BI Quick Measures is a Game Changer (@Paul_Turley) Get ready for the new Power BI navigation experience BONUS ITEMS: New Reports From Existing Datasets (@ExceleratorBI) [...]