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 [...]

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 [...]

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 [...]

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) [...]

Using Cortana with Power BI

In this video, Patrick looks at how you can enable Cortana support for Power BI and use Cortana to serve up visuals from your report. Use this page to test your Cortana card. https://app.powerbi.com/cortana/test Documentation: Use Power BI to create a custom Answer Page for Cortana Introduction to Cortana for Power BI Enable Cortana for [...]

Patrick to speak at SQL Saturday Baltimore

Register: http://www.sqlsaturday.com/615/eventhome.aspx Pre-Con registration: https://www.eventbrite.com/e/power-bi-from-the-desktop-to-the-enterprise-with-hands-on-experience-tickets-31641019140 Patrick will be speaking at SQL Saturday #615 - Baltimore on May 5th and 6th 2017. He will be doing a full day pre-con on May 5th called Power BI from Desktop to Enterprise. This will be a workshop that you can follow along with Patrick as he walks through [...]

Dynamic filtering with Power BI

In this video, Patrick looks at taking URL filtering to the next level. He shows how to use dynamic filtering with Power BI reports. He also shows a neat trick of setting a link image for Web URL fields. Filtering in Power BI: https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/ https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/

Lots of updates for Power BI plus a Power Query Editor?

Two Great New Power BI Features (@ExceleratorBI) Get your own Power Query Editor using Notepad++ (@SchreiberLars) Power BI Gateways–March Update Announcing granular tenant settings in Power BI Power BI Desktop March Feature Summary Power BI Color Theme Generator BONUS: Implementing Header-Details in Power BI (@tlachev) Power BI – Infographic for Power BI from an end [...]