fbpx

What tool do you use to optimize your Power BI dataset?

Need some help optimizing your Power BI Dataset but don't want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY! DAX Studio https://daxstudio.org/ Bravo for Power BI https://bravo.bi/ Tabular Editor 3 https://tabulareditor.com/

What tool do you use to optimize your Power BI dataset?2022-06-15T07:54:00-05:00

How do you share your Power BI Dataset for someone to review?

Need to have someone review your Power BI dataset for best practices and approval? Don't want to send them the full Power BI Desktop file and risk sharing data? Patrick walks you through some options that you have.

How do you share your Power BI Dataset for someone to review?2022-05-12T06:25:46-05:00

Demystifying Custom Partitions in Power BI

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them. Partitions in tabular models https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

Demystifying Custom Partitions in Power BI2022-04-21T07:10:14-05:00

Create Hybrid Tables with Tabular Editor for Power BI? YES!!!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! --This Year let Source = Sql.Databases("servername"), AdventureWorksDW = Source{[Name="databasename"]}[Data], internetsales = AdventureWorksDW{[Schema="dbo",Item="pbi_InternetSales"]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear --Last [...]

Create Hybrid Tables with Tabular Editor for Power BI? YES!!!2022-03-02T08:30:35-05:00

Configure Incremental Refresh with Tabular Editor

Need to configure Incremental Refresh but don't have access to the Power BI Desktop file? No problem! Patrick shows you how to set things up with Tabular Editor.

Configure Incremental Refresh with Tabular Editor2021-11-17T07:12:07-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

Unboxing Tabular Editor 3 | Reaction Video

It's here! Patrick does a reaction video when using Tabular Editor 3 for the first time with Power BI. To say he's excited is an understatement. Watch him take the wrapping off of Tabular Editor. Tabular Editor: https://tabulareditor.com/

Unboxing Tabular Editor 3 | Reaction Video2021-06-16T05:27:10-05:00

🔴 Tabular Editor 3 & Power BI Q&A – LIVE w/ Daniel Otykier & Marco Russo (June 12, 2021 – Take 2)

Join us live as we talk about Tabular Editor 3 and answer your questions about Power BI! With special guest, Daniel Otykier & Marco Russo! Connect with Daniel Otykier: Tabular Editor: https://tabulareditor.com/ Twitter: https://twitter.com/DOtykier Connect with SQLBI: Website: https://sqlbi.com YouTube: https://www.youtube.com/sqlbi Marco Russo: https://twitter.com/marcorus Alberto Ferrari: https://twitter.com/FerrariAlberto 📢 RULES FOR Q&A: 📢 👉 Put [...]

🔴 Tabular Editor 3 & Power BI Q&A – LIVE w/ Daniel Otykier & Marco Russo (June 12, 2021 – Take 2)2022-08-21T14:51:31-05:00

My CHECKLIST for troubleshooting Power BI Performance

We OPTIMIZE PERFORMANCE on a lot of models for Power BI. And, over the years, we start with the same first few things. Adam walks you through his steps. Performance Analyzer: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer DAX Studio: https://daxstudio.org/ Tabular Editor: https://tabulareditor.com/ Best Practice Rules: https://powerbi.microsoft.com/blog/best-practice-rules-to-improve-your-models-performance-and-design-v1-1/ Guidance Docs: https://docs.microsoft.com/power-bi/guidance/ One Checkbox video: https://www.youtube.com/watch?v=RnDdDlozcdo

My CHECKLIST for troubleshooting Power BI Performance2021-05-20T06:43:55-05:00

Tools to take Power BI to the NEXT LEVEL

We've mentioned them multiple times but now to bring them all together. These are the TOOLS you need to take Power BI to the NEXT LEVEL! Tools we use every day! Performance Analyzer: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer External tools in Power BI Desktop https://docs.microsoft.com/power-bi/transform-model/desktop-external-tools DAX Studio: https://daxstudio.org/ Tabular Editor: https://tabulareditor.com/ Best Practice Rules: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ ALM Toolkit: http://alm-toolkit.com/ Guidance [...]

Tools to take Power BI to the NEXT LEVEL2021-05-13T06:18:59-05:00
Go to Top