SQL Server has GA'd!!! We also had a lot of updates for Power BI! Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M (@technitrain) Power BI Desktop May Update Feature Summary Smarter Auto-Generated Insights with Complex Filters Power BI gateways – May Update SQL Server 2016 is generally [...]
With the release of Microsoft SQL Server 2016, I look at how Reporting Services and Power BI work together. From the Power BI mobile app, to pinning visualizations to a dashboard and how Reporting Services handles Power BI Desktop files.
Donate: https://donate.rednoseday.org/ Red Nose Day: http://rednoseday.org/ Paul Turley gives a recap of the PASS BA conference from his perspective mentioning Power BI and Excel. Jen Underwood talks about moving to Predictive Analytics. We have some tips for Dashboard makeovers. Ginger Grant talks about using R within SQL Server 2016. Power BI and Excel–the Dynamic Duo [...]
I walk through using a DirectQuery connection with SQL Server and the Power BI service. I start with Power BI Desktop, show how to configure the enterprise gateway, and then show how it looks in the Power BI service.
Steve Howards looks at working with OData and OAuth with Power BI. Bill Anton looks at prototyping and comparing Power BI Desktop to Power Pivot/Excel. We also had a few updates from the Power BI team regarding Q&A working with direct connections via the enterprise gateway, Query Parameters and Templating with Power BI Desktop and [...]
I look at what a UPN is and how you can use the new Map user name feature to create UPN mappings for Analysis Services Live connections going through the enterprise gateway for Power BI. This allows you to not have to create an alternate UPN suffix in your local Active Directory.
I look at the Row-Level Security (RLS) feature within the Power BI service for Cloud models and DirectQuery. This does not cover Row-Level Security within Analysis Services as that is a different topic. This also does not look at the SQL Server Database Engine RLS feature within SQL 2016.
Last day at the PASS Business Analytics conference. More time in the exhibition hall. Attended a few sessions and relaxed with some friends. Ended up doing a video walk in downtown with a friend. Which was awesome! Music by https://soundcloud.com/jeff-kaale
For my third day here, I spent most of my time in the Exhibition hall interacting with folks. I did manage to catch a few small parts of some sessions. I then snuck out to attend the Bay Area Microsoft BI User Group which was in Mountain View. Music by: https://soundcloud.com/jeff-kaale
Day 2 of my San Jose/PASS BA Conference trip. This was pre-con day. I spent most of the day helping to setup the Microsoft Booths in the exhibition hall. Met up with a friend for lunch also. Music By: https://soundcloud.com/john-butler-trio/ocean-2012