Not a coder? Don't understand DAX syntax? DAX can be intimidating and difficult to learn. Frustrating even! Learning DAX can make Power BI very rewarding. Adam has some resources to get you started in your journey. Beginning the journey MS Learn: User DAX in Power BI Desktop (Free) SQLBI: Introduction to Data Modeling for Power [...]
Calculation Groups in Power BI can be amazing! Patrick shows you how you can create these common patterns with just one click using Tabular Editor. Blog: https://www.esbrina-ba.com/time-intelligence-the-smart-way/ Calculation Groups: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions Tabular Editor: https://tabulareditor.com
Ever run into an issue where a duplicate name doesn't show up? Is it being aggregated? Patrick looks at a few ways you can avoid the duplicate name from disappearing in Power BI.
The XMLA Endpoint in Power BI can be very powerful. Adam looks at what it is and how to get started with it. If you are using Power BI Premium or Premium Per User, you need to know about this! Live Stream Question: https://youtu.be/_SLFZiA3peU?t=1229 XMLA Endpoint Documentation: https://docs.microsoft.com/power-bi/admin/service-premium-connect-tools Troubleshooting XMLA Connectivity: https://docs.microsoft.com/power-bi/admin/troubleshoot-xmla-endpoint Refreshing a single [...]
When is a date not a date? We all use them in our data. Patrick looks at how data types can be a tricky thing in Power BI. Be aware of what you are working with in order to avoid this problem in your charts.
Using a parent/child hierarchy? Check out how we diagnose performance when using some of the PATH DAX functions in Power BI and also how to make this report faster! PATHCONTAINS Reference: https://dax.guide/pathcontains/
Check out how using Small Multiples in Power BI can help you CRUSH requirements and satisfy business requests to make amazing reports! Patrick also has a neat trick for you. Documentation: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-small-multiples
There are 3 signs that we look for to help tell us it's time to optimize your Power BI report. Adam looks at all 3 to help get you started in making your reports faster. Technique to improve Power BI report perf by reducing visuals https://www.youtube.com/watch?v=kkIXtvU1AiM Debugging a slow Power BI report with Phil Seamark [...]
Frustrated that a you can only do a full refresh? Patrick takes it to the next level by showing how you can refresh only a single table in your Power BI dataset. This is a great option for targeted refresh and avoid potential overhead. Processing Options: https://docs.microsoft.com/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services?view=asallproducts-allversions Refresh Types: https://docs.microsoft.com/azure/analysis-services/analysis-services-async-refresh Elegant BI Blog: https://www.elegantbi.com/post/datarefreshintabulareditor https://www.elegantbi.com/post/processingmanager
Can a Power BI Dataset be setup to refresh without an actual user? It would be great from an automation perspective and to avoid being tied to someone specific. Adam digs in. Service Principal Video: https://www.youtube.com/watch?v=1SO19uik1rw Add-DataGatewayClusterUser (DataGateway CMDLET - Add to Admin List) https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusteruser?view=datagateway-ps Add-DataGatewayClusterDatasourceUser (DataGateway CMDLET - Add to Datasource User list) https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusterdatasourceuser?view=datagateway-ps [...]