fbpx

Native Query: Be careful when using in Power BI

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 BI2019-09-11T07:19:02-05:00

6 ways to go bananas with Column from Examples in Power BI

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 BI2019-08-15T07:39:26-05:00

Column Profiling in Power BI Desktop

Adam walks through column profiling within the Power BI Desktop. This includes the latest updates with the general availability (GA) within the April 2019 Power BI Desktop release. Demo files: https://guyinacu.be/demofiles

Column Profiling in Power BI Desktop2019-05-09T10:05:09-05:00

Power BI Paginated, DAX, Power Query and more… (April 22, 2019)

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

Power BI Paginated, DAX, Power Query and more… (April 22, 2019)2019-04-22T10:05:18-05:00

Fixing a connection issue with Azure Databricks in Power BI

Getting "Failed to load data model" for an Azure Databricks DirectQuery connection in Power BI? Adam hit it too and walks through how to fix it in Power BI Desktop using Power Query.

Fixing a connection issue with Azure Databricks in Power BI2019-04-16T10:05:10-05:00

Use Power BI Web From Example over multiple URLs

Wil Reynolds asked an awesome question about how to use multiple URLs with the web from example Power BI feature. The magic is with Power Query functions and parameters. Patrick has you covered!

Use Power BI Web From Example over multiple URLs2019-03-06T10:05:02-05:00

Populate a Power BI parameter list using a query

Patrick shows you how to populate a Power BI parameter list using a query. This can help you avoid manually entering a list, or just having free text.

Populate a Power BI parameter list using a query2019-02-20T10:05:50-05:00

Visual Vocab, Power Query Keyboard Shortcuts, Power BI Dataflows and more… (December 17, 2018)

Catch the last Power BI roundup for 2018! Merry Christmas, happy holidays and have a great New Year! ?❄? Financial Times Visual Vocabulary: Power BI Edition (@SQLJason) Power Query Advanced Editor keyboard shortcuts (@Dmaslyuk) Power BI Developer community November update Power BI Dataflows and Azure Data Lake Storage Gen2 Integration Preview Power BI Desktop December 2018 [...]

Visual Vocab, Power Query Keyboard Shortcuts, Power BI Dataflows and more… (December 17, 2018)2018-12-17T10:05:08-05:00