fbpx

Loot Crate Unboxing – July 2017 (Animation)

This month's Loot Crate theme was Animation. It included Bob's Burger, Rick & Morty, Futurama and Teenage Mutant Ninja Turtles Affiliate Link if you want to help support Guy in a Cube: http://bit.ly/2cNY20R

Loot Crate Unboxing – July 2017 (Animation)2017-07-28T12:05:42-05:00

SQL Saturday Atlanta and Women in Technology – Adam and Patrick Unplugged – July 2017 [EP5]

In this episode of the Adam and Patrick Unplugged show, we are at SQL Saturday Atlanta and talked with a few folks there. We have some SSIS, some stories, and a good discussion about Women in Technology! Tim Mitchell (@Tim_Mitchell) - 0:21 Rie Irish (@IrishSQL) - 13:30 Julie Smith (@JulieChix) - 29:17

SQL Saturday Atlanta and Women in Technology – Adam and Patrick Unplugged – July 2017 [EP5]2017-07-28T10:05:56-05:00

Community posts and a Power BI birthday

Using GENERATE and ROW instead of ADDCOLUMNS in DAX (@marcorus) Ranking Values with Measures (@powerbitips) How To Find The Latest Custom Visuals In #Power BI? For Example Power KPI (@gilra) Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing (@mmarie) POWERBI EMBEDDED WITH ONENOTE (@pkamasani) Happy Second Birthday to Power BI BONUS ITEMS: Optimizing [...]

Community posts and a Power BI birthday2017-07-27T10:41:40-05:00

Give external users access to your Azure Analysis Services server

In this video, Patrick looks at how you can provide access to your Azure Analysis Services server to external users. This is done by way of the Business to Business (B2B) capabilities of Azure Active Directory. He then takes it to the next level and shows how you can then take advantage of this within [...]

Give external users access to your Azure Analysis Services server2017-07-26T10:05:12-05:00

Free book, Updates for SSRS and SSAS and an updated Power BI gateway

Online Book: Analytics with Power BI and R (@leila_etaati) When to Use SUM() vs SUMX() (@ExceleratorBI) Model Comparison and Merging for Analysis Services SQL Server 2017 Reporting Services Release Candidate now available Power BI On-premises data gateway – July Update is now available! BONUS ITEMS: Value.Compare in Power BI, An Advanced Power BI Class Excerpt [...]

Free book, Updates for SSRS and SSAS and an updated Power BI gateway2017-07-20T10:05:00-05:00

Report level measures with Power BI live connections

In this video, Patrick looks at how you can create report level measures, within Power BI Desktop, against SQL Server Analysis Services Tabular live connections, or against a Power BI service dataset live connection. He also explains what is meant by report level measures. Bust out your DAX toolbelt and have a look!

Report level measures with Power BI live connections2017-07-19T10:05:20-05:00

Guy in a Cube hanging out with Andy Leonard from DataDriven.TV

Patrick and Adam were at SQL Saturday Atlanta. While there, they caught up with Andy Leonard from DataDriven.TV and participated in one of their podcasts. They did a Facebook live stream and posted this on their podcast channel. Adam had his camera equipment and also grabbed it. Here is the Guy in a Cube video [...]

Guy in a Cube hanging out with Andy Leonard from DataDriven.TV2017-07-18T11:19:10-05:00

Managing Power BI Premium capacity

In this video, Adam looks at how to manage the Power BI Premium capacity that you have purchased. He looks at what Global Admins can see, how you can assign capacity admins and users with workspace assignment, along with how to assign workspaces to a Power BI Premium capacity.

Managing Power BI Premium capacity2017-07-11T12:48:42-05:00

Reset a streaming dataset in Power BI (Minute Monday)

In this Minute Monday, Patrick shows you how to reset data that is within a streaming datset in Power BI. He figured this out when trying to setup a demo with a streaming dataset and then wanting to start over.

Reset a streaming dataset in Power BI (Minute Monday)2017-07-10T10:05:46-05:00

Lots of Power BI updates and some DAX

Use Multiple Connections Between Tables (@PowerBITips) The ALL() Function in DAX (@ExceleratorBI) Responsive visualizations coming to Power BI Power BI Desktop July Feature Summary Power BI Service and Mobile June Feature Summary BONUS ITEMS: Data Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks (@Technitrain) Integrate Power BI into Your Application: Part [...]

Lots of Power BI updates and some DAX2017-07-06T12:06:19-05:00