Chris Webb's BI Blog
WEBJul 21, 2024 · The logs for your on-premises data gateway contain a lot of information that is useful for troubleshooting and performance tuning. The contents of the logs are documented here and there a several great solutions out there for reporting on their contents: there’s a Microsoft-provided template and Rui Romano’s more sophisticated monitoring solution here (there’s also another, even better ...
Chris Webb's BI Blog: Optimising The Performance Of Power …
WEBJun 7, 2020 · Found the answer myself. To only expand a selected column from the second table using a Table.Join, the easiest is to pre-prepare the second table before the merge operation, i.e. a sub-select on the second table as below
About - Chris Webb's BI Blog
WEBAbout. My name is Chris Webb, and I’m a specialist in Power BI, Analysis Services, MDX, Power Pivot, DAX, and Power Query. I’ve been blogging about Microsoft BI for over 10 years, and racked up over 1500 posts here! I also speak at a number of conferences including SQLBits, the PASS Summit, the PASS BA …
How Query Folding And The New Power BI Dataflows Connector …
WEBAug 22, 2021 · You may have noticed that a new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – which you may be surprised to learn was not possible before. In this post I thought I’d take a look at how much of an improvement in performance this can make to dataset refresh performance.
Optimising The Performance Of Power Query Merges In Power BI, …
WEBJun 14, 2020 · In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only if your data is sorted. But what if your data isn’t sorted? Can those other join algorithms give you better performance? …
Chris Webb's BI Blog: How Defining Too Many Measures In A …
WEBAug 15, 2021 · You probably know that it’s a best practice to build your Power BI datasets in a separate .pbix file from your reports – among other things it means that different people can develop the dataset and reports. You may also know that if you are building a report in Power BI Desktop with a Live connection to a published dataset or Azure Analysis Services you can define your own measures inside ...
Optimising The Performance Of Power Query Merges In Power BI, …
WEBAug 30, 2020 · In a late addition to the series of posts that I started here a few months ago, I thought it would be useful to look at how to optimise the performance of a rare (but nonetheless useful) type of merge: the cross join.Cross joins are not available as a join kind in the Table.Join or Table.NestedJoin M functions but there are two ways of creating them in Power Query:
Chris Webb's BI Blog
WEBJun 30, 2024 · A few weeks ago I wrote a post on how to improve the results you get from Power BI Copilot by editing the Linguistic Schema. As I mentioned, though, there are in fact lots of different ways that you as a Power BI semantic model developer can improve the results you get from Copilot and in this post I’ll show you another one: setting the Row Labels and Key Columns properties on a table.
Video: Advanced Analytics Features In Power BI - Chris Webb's …
WEBMay 16, 2021 · Chris Webb Power BI, Power BI Desktop May 16, 2021 1 Minute. Following on from my last post, another SQLBits session of mine I wanted to highlight was “Advanced Analytics Features In Power BI”. The subject is a bit outside my normal area of expertise but it’s also one that I don’t think gets enough attention: it’s all the features ...
Chris Webb's BI Blog: Seventeenth Blog Birthday
WEBDec 30, 2021 · Chris, although your blog might serve the purpose to help you learn and to archive important things that you find in Power BI, Power Query and other Microsoft BI and data tools, it serves a very important purpose for those like me who follow you and gain knowledge from your hard work and dedication to the craft.