In this video, Patrick and I talk about what is on our minds. We take a look at some custom visuals within Power BI and also talk about the On-Premises Data Gateway. What is Adam and Patrick Unplugged? 0:24 Custom Visuals on Office Store - 6:22 Play Axis Custom Visual - 10:43 Gateway updates - [...]
In this video, I show you how you can use Chrome to have multiple logins to Power BI, or Office 365, without using incognito, or in-private or anything else. This was a tip I got from Chris Webb, who found it from James Callaghan. Chris Webb's Blog James Callaghan's Blog How to Use Multiple Browser [...]
This month's LootCrate theme was Primal. It included Logan, Winston from Overwatch, Jurassic Park and Predator. Affiliate Link if you want to help support Guy in a Cube: http://bit.ly/2cNY20R
Using Parameters to Enable Sharing (@PowerBITips) POWER BI CUSTOM VISUALS CLASS (MODULE 43 – GANTT) (@knight_devin) IF and Filter are Different! Be Careful (DAX) (@Rad_Reza) Filter Context references https://msdn.microsoft.com/en-us/library/gg413423(v=sql.110).aspx https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/ Announcing Custom Cache Refresh Schedules in the Power BI Service Custom visuals now available in the Office store BONUS: Unexpected side effects of table filters [...]
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 [...]
In this video, I show you how to filter Power BI reports, within the Power BI service, using a URL query string. This is actually documented here - https://powerbi.microsoft.com/en-us/documentation/powerbi-service-share-unshare-dashboard/#share-just-a-report In addition to showing you how to filter a single field, I also show a hack for you to be able to filter multiple fields.
Two Great New Power BI Features (@ExceleratorBI) Get your own Power Query Editor using Notepad++ (@SchreiberLars) Power BI Gateways–March Update Announcing granular tenant settings in Power BI Power BI Desktop March Feature Summary Power BI Color Theme Generator BONUS: Implementing Header-Details in Power BI (@tlachev) Power BI – Infographic for Power BI from an end [...]
The release of SQL Server 2016 included many new and innovative features. One that intrigued me the most was the integration of Mobile Reports into SQL Server Reporting Services (SSRS). Recently, I was planning a full-day hackathon focused on the Microsoft Data Platform and I was asked to show drill from an SSRS Mobile report [...]
In this video, I answer a question I get fairly often. Can I use the audit log if I have the Power BI service administrator role assigned to me within Office 365. I also make an announcement about the future of Guy in a Cube. Admin portal doc Audit log doc Power BI Auditing for [...]
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 [...]
