In this video, I show how you can configure Reporting Services to integrate with Power BI and then pin visualizations from a paginated report to a Power BI dashboard. There are three main steps you have to do to get this to work. Register with Power BI in Reporting Services Individual user sign in Pinning [...]
In this video, I show you how you can download a PBIX (Power BI Desktop file) from the Power BI service for a given report. Reports have to have been published after November 24. 2016 for the feature to be available. This does work with Live or DirectQuery reports. Ginger Grant's Blog talking about this [...]
This month's LootCrate theme was Magic. It included Doctor Strange, Fantastic Beasts from the Harry Potter world, Game of Thrones and some other items. Affiliate Link if you want to help support Guy in a Cube: http://bit.ly/2cNY20R
Not Folding; the Black Hole of Power Query Performance (@Rad_Reza) Calling Microsoft Flow From Power Query And Power BI (@technitrain) Analysis Services Tabular Is (Finally) NUMA-Aware! (@SQLbyoBI) What’s new in SQL Server 2016 SP1 for Reporting Services What's New in SQL Server vNext BONUS: Excel Workbook Connection to Local Power BI Desktop (@ExceleratorBI) Grouping and [...]
In this video, I look at how you can add a Power BI report as a tab within a channel in Microsoft Teams!
e had a lot of announcements come out of PASS Summit 2016. Here is a recap of some of the big items. Here is the roundup for November 3, 2016. Power BI Desktop October Feature Summary Grouping and Binning; Step Towards Better Data Visualization Announcing a Technical Preview of Power BI reports in SQL Server [...]
Last week was PASS Summit 2016, and I spent a lot of time in the SQL Clinic answer your questions! I wanted to highlight a few of the questions that I was asked in the Clinic and share that out with everyone. PASS Summit 2016 / #SQLFamily montage https://www.youtube.com/watch?v=0R2wL1oMFrg Questions: 1. Can you use a [...]
PASS Summit 2016 is a wrap! Every year it is like a #SQLFamily reunion and I wanted to put together something to try and convey that. From sessions to networking to the SQL Clinic and the nightlife (SQL Karaoke anyone?) It is the highlight of the year! Special thank you to everyone that helped me [...]