Expand lists in Power BI (also a look at M Syntax)
I show how you can take a table that lists "Record" and expand that within Power BI. This also works with Power Query. I have a look at the M Syntax and show a cleaner approach.
Contest Winners, R Maps, Data Modeling – Roundup #35
Adam Saxton is a Microsoft employee working on Business Intelligence products. The Power BI report contest winners were announced! Get a quick start with R Map visualizations. A look at how to get started with SQL 2016. And, some data modeling tips. Meet the Winners of the Best Report Contest R Maps in Microsoft Power [...]
3 things to get up and running with KPIs in Reporting Services 2016 (CTP 3.3)
I look at three things you need to do to create and use KPI's in SQL Server Reporting Services 2016. This looks specifically at CTP 3.3. I go through creating a shared dataset, creating the KPI and then setting up refresh for the KPI/Dataset. Working with KPIs in Reporting Services
Roundup #34 (Compression, RLS and updates)
We start with a new content pack for Power BI for Insightly CRM. We got a new preview of the Mobile Report Publisher for Reporting Services. Matt Allington talks about a compression tip for Power Pivot. Patrick LeBlanc talks about Row-Level Security with SQL Server 2016 and how to take advantage of that from Reporting [...]
5 steps to configure Power BI Mobile apps with Intune
I walk through how you can configure the Power BI Mobile app within Intune to deploy a managed mobile application for your enterprise organization. This approach can be used for either the iOS app or the Android app. Configure and deploy mobile application management policies in the Microsoft Intune console
Roundup #33 (Gateway, Desktop, Box and more…)
This week the enterprise gateway for Power BI has GA'd. So, that means it is time to move off of the Analysis Services Connector. There were a lot of new updates for Power BI Desktop, including the ability to add measures to a DirectQuery model. Chris Webb looks at how to query DMVs for Power [...]
Are you mobile?
I take a look at the different mobile apps for Power BI. From the iOS apps (for iPhone and iPad), to Android and the new Windows 10 Universal App. You can also connect to an on-premises Reporting Services server to look at mobile reports. Spud Trooper and Darth Potato are there to help!
Roundup #32 (Corporate Sabotage???)
This week we look at the newly announced Windows 10 Universal application for Power BI. We also take a look at content packs working with groups within Power BI, and a neat URL trick to get to your report page directly. We then wrap it up with Rob Collie's look at traditional BI with a [...]
A sweet feature in PowerPoint!!!
A look at a sweet feature I stumbled on in PowerPoint while I was in Atlanta, Georgia. Music by Jeff Kaale - https://soundcloud.com/jeff-kaale/
Roundup #31 (Content Pack, Data viz and more)
I start this week with a new content pack for Azure Search. A big update for the Power BI Mobile apps. Ability to pin custom visualizations to your Power BI Dashboard. A great post about Data Visualizations from Buck Woody. An awesome tidbit from Teo Lachev regarding the ACE Driver and bitness. And a second [...]