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
There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools. Performance tuning with materialized views using dedicated SQL pool in [...]
Join us live as we answer your questions about Power BI! 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 [...]
Using Microsoft Teams? Have a central place for your Power BI folks in your organization? This efficient approach will help you to get your question to the right people! At the same time cutting down the noise for other folks. Steve Campbell https://twitter.com/PowerBISteve https://www.linkedin.com/in/powerbisteve/ Power BI Support Channel: Microsoft Teams Tips https://powerbi.tips/2022/04/power-bi-support-channel-in-teams/ Power BI adoption [...]
Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get it working.
Have you heard about Azure Synapse Analytics! Is your data in Synapse? It's so much more than SQL Server! Adam and Patrick look at why you should care about it! What is Azure Synapse Analytics? https://docs.microsoft.com/azure/synapse-analytics/overview-what-is
