Patrick looks at a few data modeling best practices in Power BI and Analysis Services. These are things we see customers doing on a regular basis and you should be aware of it.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup150 2 Minute Tuesday: https://guyinacu.be/connecttools Patrick's tech video: https://guyinacu.be/powerapps Adam's tech video: https://guyinacu.be/reducedatasetsize Sources Chart With Different Scales (@dagdooe) Blank row in DAX (@FerrariAlberto) What’s new for SQL Server 2019 Analysis Services RC1 Change to Summarized Data Export behavior with [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup142 Tech Video: https://guyinacu.be/paginatedtips Sources Introducing Calculation Groups (@marcorus) Customer Stories sessions from MBAS 2019 (@SQLAllFather) Updated(!) Guide To Selecting Between Azure Analysis Services And Power BI Premium (@DaveRuijter) Introduction to Charticulator: Create Custom Visual – Part 1 (@leila_etaati) Announcing Bring Your Own [...]
Adam walks through how to setup a live connection to Analysis Services, or Azure Analysis Services, in Power BI Desktop. This also involves getting things working with the On-Premises Data Gateway.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick's tech video: https://guyinacu.be/modelview Adam's tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing values for the total (@FerrariAlberto) Power Query Memory Usage, Dataflow Container Size And Refresh Performance (@cwebb_bi) Creating a Fiscal Saturday Calendar (@kpuls) Governance settings for Power [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup129 2 Minute Tuesday: https://guyinacu.be/geekshirts Patrick's tech video: https://guyinacu.be/webfromexample Adam's tech video: https://guyinacu.be/adminportal Sources Calculation Groups in DAX – first impressions (@marcorus) EXPLORING POWER BI’S KEY INFLUENCERS (@Jcrit44) Power BI Premium Deployment and Management Whitepaper added! Tailoring help and support for Power BI [...]
Power BI Visual Usability Checklist (@mmarie) Get the most out of Power Query in Power BI Dataflows (@diverdown1964) Analysis Services is 20 years old! Announcing new AI Capabilities for Power BI to make AI Accessible for Everyone Power BI Desktop November 2018 Feature Summary BONUS ITEMS: Tableau to Power BI: Highlighting with Set Actions (@dataveld) [...]
In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX [...]
In this Power BI Tutorial, Patrick will show you how you can grow up a Power BI Desktop file (PBIX) to Analysis Services. He's all about learning the clicks! This is a Power BI tutorial worth watching! You can build your model within Power BI Desktop and then use Azure Analysis Services to migrate to [...]
In this video, Patrick looks at when you need the On-Premises Data Gateway when using Azure Analysis Services (Azure AS). Do we need it with Power BI? Or just Azure AS? What's the difference? Patrick also shows you why your gateway may not show up in the Microsoft Azure portal.