Patrick looks at native query and why you should be careful when using it in Power BI. He looks at what native query is, what to consider when using it, and how to monitor what query folding, in Power Query, is or is not doing.

Native Query: Be careful when using in Power BIpleblanc2019-09-11T07:19:02-05:00

Patrick continues the journey of data modeling best practices with looking at where to create your columns within Power BI. In the data source, in Power Query or using a DAX calculated column? High Memory Usage and Calculated Columns (@tlachev) VertiPaq Analyzer (Free)

Where to create your columns in Power BI | Data Modeling Best Practicespleblanc2019-09-04T08:13:06-05:00

Adam look at Power BI build permissions with shared datasets. Taking the mystery out of how you can interact with datasets and know what to do if you can't use it. This also looks at how Power BI free users can use shared datasets with Power BI Premium.

What the heck are BUILD PERMISSIONS in Power B?!?asaxton2019-08-25T08:33:55-05:00

Adam shows you two things to reduce your Power BI dataset size. These are both things he commonly sees with Power BI reports and could potentially save you a lot of space and improve refresh times along with report performance. Data reduction techniques for import modeling

2 ways to reduce your Power BI dataset size and speed up refreshasaxton2019-08-22T05:41:27-05:00

Patrick takes a look at how you can integrate PowerApps with Power BI to get a bananas experience. Updating the PowerApp does something special with the Power BI report. Create a PowerApp: https://docs.microsoft.com/powerapps/maker/ PowerApps custom visual: https://docs.microsoft.com/powerapps/maker/canvas-apps/powerapps-custom-visual

POWERAPPS and POWER BI can do what?!? It’s bananas!pleblanc2019-08-21T07:47:44-05:00

Patrick is going bananas with these different ways that Column from Examples can help you shape your data without writing code in Power BI. This feature really helps you to be efficient! Download sample Want to download the sample report? Hit the download button below.

6 ways to go bananas with Column from Examples in Power BIpleblanc2019-08-15T07:39:26-05:00

Patrick looks at how to create and use a Power BI Hierarchy within Power BI Desktop. Hierarchies can help to provide correct data usage within your Power BI reports. Download sample Want to download the sample report? Hit the download button below.

How to create and use a Power BI Hierarchypleblanc2019-08-04T11:55:34-05:00