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-07T16:00:13-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-22T08:11:39-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-14T06:08:56-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-02-25T07:44:04-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-16T12:59:36-05:00

Power BI Desktop: How to find the native query after query folding

Have you wondered how to find the native query in Power BI Desktop after query folding does its thing? Do you even know what query folding is? In this video, Adam looks at how you can find the query that will be sent to your data source and a few things to be aware of. [...]

Power BI Desktop: How to find the native query after query folding2018-12-04T08:06:01-05:00

Fuzzy match / merging in Power BI Desktop (October 2018)

In this video, we look at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop. This feature is incredibly powerful when it comes to data matching and can be adjusted to meet your needs.

Fuzzy match / merging in Power BI Desktop (October 2018)2018-10-24T08:32:07-05:00

Mashup Engine Query Monitor for Power BI Refresh

In this video, Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh.   MEQM Files - https://github.com/guyinacube/demo-files/tree/master/video%20demos/MEQM

Mashup Engine Query Monitor for Power BI Refresh2018-10-10T09:30:12-05:00

Power BI Minesweeper, Visual reference, World tour and more… (October 8, 2018)

Fun with DAX – Minesweeper (@PhilSeamark) Power BI Visuals Reference (@marcorus) Comparing Rows in Power Query Part 1 (@PowerPivotPro) Developing with Power BI Embedding (Part 1) (@criticalpath) See Power BI Preview Features in action at the Power BI World Tour BONUS ITEMS: Can You Use Power Query In Power BI Or Excel To Write Data [...]

Power BI Minesweeper, Visual reference, World tour and more… (October 8, 2018)2018-10-08T07:28:35-05:00