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

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

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!

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

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.

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.

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

Fixing Time Calculations in Power BI

In this video, Patrick shows why you may hit some issues with time calculations and how to fix time. He typically sees this when using a Data Warehouse.

Power BI and Microsoft Flow – Monitoring your data

In this video, Patrick shows how you can use Microsoft Flow, combined with Power BI, to monitor data and alert you when something is available. This takes advantage of a streaming dataset and using the schedule recurrence in Microsoft Flow to trigger an action as Patrick wasn't using anything else to trigger it. You have [...]