fbpx

Power BI case sensitivity, Power Query stored procedure and more… (October 14, 2019)

Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup156 2 Minute Tuesday: https://guyinacu.be/easyparameters Patrick's tech video: https://guyinacu.be/referencequeries Interview: https://guyinacu.be/powerbiqueen Guy in a Cube courses: https://guyinacu.be/courses Sources Power Query – Function to Execute an SQL Procedure (@Laura_GB) Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI [...]

Power BI case sensitivity, Power Query stored procedure and more… (October 14, 2019)2019-10-14T07:22:31-05:00

Inside Power Query reference queries for Power BI and Excel

Chris Webb joins Patrick to look at what happens when you use reference queries for Power Query. This applies to both Power BI and Excel. Chris also looks at how change the behavior to make things a bit faster. Data Privacy Blog: https://blog.crossjoin.co.uk/2018/12/27/data-privacy-settings-data-refresh-performance-power-bi-excel/ Connect with Chris Webb: Twitter: https://twitter.com/cwebb_bi Blog: https://blog.crossjoin.co.uk/

Inside Power Query reference queries for Power BI and Excel2019-10-10T10:01:21-05:00

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