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