Chris Webb's BI Blog
Nov 24, 2024 · 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 ...
Chris Webb's BI Blog
Nov 17, 2024 · Power BI reports are usually used to display numeric data. However it is reasonably common to have text data in a semantic model too and for this to be displayed on a report, and while visuals like the new text slicer allow you apply filters to the text, large amounts of text can still be difficult for end users to make sense of. Recently I was wondering if Power BI Copilot can be used to ...
Chris Webb's BI Blog
Nov 3, 2024 · If you’ve looked into using Copilot with Power BI, you’ll know that you need a capacity to use it: a P1/F64 or greater.Something I learned recently, though, is that the current Power BI Copilot capabilities are only accessible via a side pane to a report and it’s the report that needs to be stored in a workspace on a P1/F64+ capacity …
Chris Webb's BI Blog
Oct 20, 2024 · If you’ve looked into using Copilot with Power BI, you’ll know that you need a capacity to use it: a P1/F64 or greater.Something I learned recently, though, is that the current Power BI Copilot capabilities are only accessible via a side pane to a report and it’s the report that needs to be stored in a workspace on a P1/F64+ capacity …
Solution for monitoring Power BI/Fabric on-prem data gateways
Oct 27, 2024 · If you’re the admin for a large Power BI/Fabric tenant you’ll know how important it is to monitor your on-premises data gateways: if they aren’t working then no-one will be able to refresh any semantic models or dataflows connected to on-prem sources.
Get better results from Power BI Copilot - Chris Webb's BI Blog
Jun 9, 2024 · Everyone is excited about Power BI Copilot, and the newly-announced preview of being able to use Copilot to ask questions about all the data in your semantic model rather than just what is shown in a report is a massive step forward. However amazing the LLMs used behind the scenes are, though, the quality of the results your users get from this new Copilot preview depends on a number of ...
Chris Webb's BI Blog
Some time ago I wrote a post about how you can use the DISCOVER_CALC_DEPENDENCY DMV to get a list of all the tables, columns and relationships referenced by a DAX query. That’s really useful and indeed the new INFO.CALCDEPENDENCY DAX function allows you to do the same thing without all the complexity of calling a DMV. However this doesn’t quite give you everything you need to solve one ...
Chris Webb's BI Blog
Sep 8, 2015 · A blog about Microsoft Fabric, Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query and Excel for BI
About - Chris Webb's BI Blog
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,…
Chris Webb's BI Blog
Sep 5, 2021 · Something that got lost in all the excitement around Excel reports connected to Power BI datasets working in Excel Online is the fact that Excel reports connected to the Excel Data Model – aka Power Pivot – now work too (although I did mention it here).Right now it’s not possible to refresh the data stored in the Excel Data Model if you are connected to …