fbpx

Adam & Patrick Unplugged – EP1

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

Adam & Patrick Unplugged – EP12017-03-31T09:00:33-05:00

Multiple sign-ins using Chrome with Power BI or Office 365

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

Multiple sign-ins using Chrome with Power BI or Office 3652017-03-28T11:32:43-05:00

Loot Crate Unboxing – Primal – March 2017

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

Loot Crate Unboxing – Primal – March 20172017-03-27T10:33:44-05:00

Custom visuals, DAX and parameters

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

Custom visuals, DAX and parameters2017-03-23T09:03:26-05: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-05:00

Filter Power BI reports using a URL query string

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.

Filter Power BI reports using a URL query string2017-03-21T11:19:18-05:00

Lots of updates for Power BI plus a Power Query Editor?

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

Lots of updates for Power BI plus a Power Query Editor?2017-03-16T07:00:06-05:00

Drill from a mobile report to a paginated report in SSRS (SQL Server)

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

Drill from a mobile report to a paginated report in SSRS (SQL Server)2017-03-15T01:00:00-05:00

Can I use the audit log if I’m a Power BI Admin?

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

Can I use the audit log if I’m a Power BI Admin?2017-03-14T09:55:19-05: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-05:00