Dec 1, 2005 · For me the biggest new feature in the January 2025 release of Power BI Desktop is the new TMDL View; many other people like Marco are excited about it too. For more advanced Power BI developers (and honestly, I don’t think you need to be that advanced to get value out of it) it makes certain editing tasks for semantic models much simpler, and while I won’t be abandoning the main Power BI ...

4 days ago · People still use Power BI semantic models as data sources all the time. This is either because they don’t know any better, because they can’t get access to the underlying data sources, or because they want to get the result of any DAX calculations on the model. If you do need to extract large ...

Dec 30, 2024 · Every year on this date I write a post reflecting on the previous year but, as you've probably guessed from the title, this is a special year: it's twenty years since I started writing this blog. Twenty years ago today on the 30th of December 2004 I …

Oct 13, 2024 · I concur with your thoughts. with advancements in genai models and power bi moving towards it (gpt4 to gpt4o) plus letting users to train how the copilot should answer from their semantic model (like that in AI skills), soon copilot in pbi will do a much much better job and the c-suite who wants answers in chatty format will …

Apr 20, 2020 · Now that Power BI is so popular, it's becoming more and more common for organisations to migrate their reports from other BI platforms to Power BI. And why not? You'll be moving to a modern, industry-leading, cloud-native BI platform and probably saving a lot of money in licensing costs too. As a Microsoft employee I…

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 Conference,…

Jul 21, 2024 · One of the great things about the SQLBits conference in the UK is the way that all the session recordings are made available for for anyone to view for free on their YouTube channel.All the recordings from the 2024 conference have now been posted and it’s a goldmine for anyone who wants to deepen their Power BI or Fabric knowledge.

Aug 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:

Jul 14, 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 ...

May 23, 2021 · My favourite Power BI announcement at the Microsoft Business Applications Summit was, without a doubt, that Excel PivotTables connected to Power BI datasets will very soon work in the browser and not just on the desktop. This is something I have wanted for a long time, way before I joined Microsoft, so this is a…