Power BI Performance Best Practices
The second edition of the only book on Power BI performance, was published in August 2024. It contains lots of info from the first edition, plus changes and new content based in Power BI, Fabric, and external tools…
Read More »Power BI–Gathering the troops
Power BI is… something beyond a reporting tool. It is hard to visualize its scope from seeing a report. First of all, it is a visualization tool not a reporting tool. The reporting part of Power BI is…
Read More »Power BI Vision
Do you have a vision for a Power BI implementation? Maybe you should. There are a lot of parts and pieces to Power BI. Do you even know what Fabric has to do with Power BI? The start…
Read More »Power BI or Fabric Monitoring
I really like the new Monitoring Hub for the Power BI Service. It is a good morning when all the models are finished and completed successfully, but it is not that good of a day if some are…
Read More »Power BI Performance–Calculated Columns versus New Column in Power Query
Most best practices today call for a new column to be create in Power Query or the source system. No matter where you add a column, it will always take up space in the semantic mode as shown…
Read More »Power BI Updates Dec 2023 Release – Preview Features
There are some new preview features in Power BI Desktop I thought were interesting. First, the On-object editing of visuals have improved significantly. Before I get to that, there is a button on the lower right of the…
Read More »Fabric Persona(s)
With the release of Fabric, the Power BI (Fabric) portal has been updated. In order for a better look and feel, Microsoft has decided to split the areas into Personas. That was so all the artifacts available will…
Read More »Show rows for attribute with No values
There was at a time, an attribute for the x-axis or value in a table to ‘Show rows with no data’. Not sure what Microsoft did with this option, but it is no longer available for some reason….
Read More »Power BI External Tools
I would like to express my appreciation for 3 Power BI External Tools. From a DBA background, you always learn some backdoor queries to monitor a SQL Server system and the infrastructure behind it. Then, someone writes a…
Read More »SQLSaturday Baton Rouge
We are at it again. SQLSaturday in Baton Rouge, LA Saturday July 29th at the LSU Business Education building – SQL Saturday Baton Rouge 2023 (#1060). We are first very thankful to the sponsors. They seem to always…
Read More »