Let’s talk about Power BI Premium – Adam and Patrick Unplugged [EP4]

In this episode of the Adam and Patrick Unplugged show, we talk about some travel updates, ragged hierarchies and a lot about Power BI Premium. Travel Update - 0:39 Ragged hierarchies - 2:15 Power BI Premium - 8:12 Travel stories - 33:27

Let’s talk about Power BI Premium – Adam and Patrick Unplugged [EP4]2017-06-30T10:59:15+00:00

Power BI Report Server, data privacy and more

Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications (@technitrain) SSAS TABULAR VS MULTIDIMENSIONAL FEATURE MATRIX (@BrettPowell76) Reusing Datasets Imported to the Power BI Service (@SQLChick) Power BI Report Server preview now available What’s new in SQL Server 2017 CTP 2.1 for Analysis Services BONUS ITEMS: How to compute index numbers at top [...]

Power BI Report Server, data privacy and more2017-05-25T09:38:29+00:00

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

Adam & Patrick Unplugged – April 2017 [EP2]2017-04-23T15:17:05+00:00

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

DirectQuery, Power BI Datasets and Analysis Services 20172017-04-20T13:19:58+00:00

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

Dynamic Filtering with Power BI and Analysis Services2017-04-18T19:52:58+00:00

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

Drill from a mobile report to a paginated report in SSRS (SSAS)2017-03-22T09:19:34+00:00

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

Upcoming EdX course on Analysis Services Tabular w/ Peter Myers (DAT225X)2017-03-10T11:50:43+00:00

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

Power BI Desktop and Mobile updates, embedding and some Power Query2017-03-16T09:01:11+00:00

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

12 Power BI Dashboards, SSAS and SSRS Updates and Power BI AMA2017-03-16T09:01:11+00:00

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

Azure SSAS, Combining data and updates for Power BI (Roundup)2017-03-16T09:01:11+00:00