Curious how to save cost when using Azure Synapse Serverless Pools? Any way to minimize the amount of data you are processing? Patrick shows you how and has a script for you! Cost management for serverless SQL pool in Azure Synapse Analytics https://learn.microsoft.com/azure/synapse-analytics/sql/data-processed Azure Synapse Toolbox https://github.com/microsoft/Azure_Synapse_Toolbox Sample Query: https://pastebin.com/iRKagQHR
It's 2023 and there are amazing things ahead! Adam looks at what will be coming for the Guy in a Cube channel, and more importantly has a question for YOU!
Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion! DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/ Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced
Think you need to always refresh your Power BI dataset even why just adding a measure? Patrick shows how you can deploy schema changes without needing to perform the refresh with Power BI Premium and the ALM Toolkit. ALM Toolkit: http://alm-toolkit.com/
Giving everyone an update on the Guy in a Cube Channel. How COPPA is affecting the channel. A break for 2019 to gear up for 2020 and more training to come! Google and YouTube Will Pay Record $170 Million for Alleged Violations of Children’s Privacy Law 🔥 COPPA, FTC, and YouTube | Everything You Need [...]
Rename Blank in a Slicer in Power BI (@ExceleratorBI) 24 Days of PowerPlatform – Day 6 – How and Where to Start? (@wstrasser) Respect Layers (@powerbitips) CHANGE BAR WIDTH ON A CONTINUOUS X-AXIS (@eSven_nl) Ask a question using natural language updates Cold Open: Business Intelligence Edition (BI Power Hour 2018) BONUS ITEMS: Dual Storage Mode; [...]
The Power BI community wanted to say thank you and happy birthday to the Power BI product and support team. The new Power BI experience was made generally available on July 24, 2015. It has enabled so many businesses and individuals to explore data in new and meaningful ways. Contributors: Ankit Patira Adam Saxton Atlanta [...]