fbpx

DAX! Uggg – Where do you start? | Power BI

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

DAX! Uggg – Where do you start? | Power BI2021-09-23T06:21:25-05:00

One Click Calculation Group in Power BI

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

One Click Calculation Group in Power BI2021-09-22T04:57:40-05:00

How to show a name more than once in Power BI

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.

How to show a name more than once in Power BI2021-09-15T06:10:26-05:00

Power BI XMLA Endpoint: Why you should care

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

Power BI XMLA Endpoint: Why you should care2021-09-09T05:15:29-05:00

When is a date not a date in Power BI?

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.

When is a date not a date in Power BI?2021-09-08T06:12:22-05:00

Case of the SLOW Power BI report: Hierarchies and RLS

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/

Case of the SLOW Power BI report: Hierarchies and RLS2021-09-02T05:11:29-05:00

CRUSHING requirements with Small Multiples in Power BI

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

CRUSHING requirements with Small Multiples in Power BI2021-09-01T05:21:17-05:00

3 signs it’s time to OPTIMIZE your Power BI report

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

3 signs it’s time to OPTIMIZE your Power BI report2021-08-19T05:29:19-05:00

Can you refresh a single table in Power BI?

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 you refresh a single table in Power BI?2021-08-18T07:10:04-05:00

Refresh your data in Power BI WITHOUT a user???

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

Refresh your data in Power BI WITHOUT a user???2021-08-12T06:23:36-05:00
Go to Top