Home » PowerBI

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 »

Power BI: Better CI/CD Integration

Microsoft took a step forward with the latest Desktop release for saving as a project – Power BI Desktop Developer Mode (Preview). This new save option separates data from the model from the report. This is a Preview…

Read More »

Power BI Performance Tuning: Data Model

There are many opportunities for performance tuning in Power BI. The main areas are the data model, visualization pane and the service. Power BI always starts with data. Once the data is modeled, the visualizations can be created….

Read More »

Power BI Metrics Has Visual For Reports

At Live!360 last week, I saw Andrew Burst show a 20 minute Fast Track of Power BI Metric. I have not used this since it was renamed from Goals. He showed a Visual for the Desktop.   This…

Read More »

Power BI Update

I found a cool site to be aware of for Power BI issues. Seems like a good place to check first before opening a support ticket. Power BI known issues – Power BI | Microsoft Docs Drill into…

Read More »

Power BI Row Level Security

Yes, there is row level security in Power BI datasets. The same functionality in Analysis Service is in Power BI through Roles. There is a difference because once the dataset is deployed to the Power BI Service (app.powerbi.com),…

Read More »