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

Drill from a mobile report to a paginated report in SSRS (SSAS)

In the first post in this series, I explained how to drill from a mobile report to a paginated report that contained parameters populated from a SQL Server database query. This was pretty simple and straightforward. What if the data in the parameter of the paginated report was populated from a SQL Server Analysis Services [...]

Upcoming EdX course on Analysis Services Tabular w/ Peter Myers (DAT225X)

I met up with Peter Myers to talk about an upcoming EdX course for Analysis Services Tabular. He wrote and primarily presented the course which is free to you. You also have the option to upgrade to get a certificate of completion if you wish. The course will be released on March 14, 2017, and is [...]

Power BI Desktop and Mobile updates, embedding and some Power Query

Web.Contents(), Caching And The ExcludedFromCacheKey Option In Power BI And Power Query (@technitrain) Extract Tabular Data From Power BI Service to Excel (@ExceleratorBI) Power BI Desktop January Feature Summary Embedding a Power BI report into Salesforce Power BI mobile phone reports now available everywhere BONUS: Power BI Desktop – 2016 Year in Review Using Power [...]

12 Power BI Dashboards, SSAS and SSRS Updates and Power BI AMA

Power BI – 12 Days of Dashboards (@SQLSamLester) New Combine Binaries Experience (@kpuls) What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services Power BI reports in SQL Server Reporting Services: Feedback on the Technical [...]

Azure SSAS, Combining data and updates for Power BI (Roundup)

Use Cases for Azure Analysis Services (Part 2) (@SQLChick) http://www.sqlchick.com/entries/2016/11/29/use-cases-for-azure-analysis-services How to Combine System and Manual Data in a Power BI Data Model (@PowerBIPro) https://www.powerpivotpro.com/2016/11/combine-system-manual-data-power-bi-data-model/ Power BI mobile apps feature summary – November 2016 https://powerbi.microsoft.com/en-us/blog/power-bi-mobile-apps-feature-summary-november-2016/ Power BI Desktop November Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/ Announcing the Preview of Download Power BI Desktop files from the web https://powerbi.microsoft.com/en-us/blog/announcing-preview-of-download-power-bi-desktop-files-from-the-web/ [...]

Announcements for SQL Server along with some tips for Power BI

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

Announcements and updates for RS, AS and Power BI

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