Author: admin

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 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 »

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 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 »

Include Relationship columns – Power BI

I always wondered if there was a way to exclude the related table when importing into a Power BI Dataset. Most models I work on have dimension and fact tables with foreign keys. After importing into PowerQuery, there…

Read More »

Updates – Power BI Goals

The idea of creating scorecards can be accomplished with using Goals in Power BI Service. Goals allow the tracking progress in a business or event through the internet and even a mobile app. Upper management can have a…

Read More »

Power BI Deployment Pipeline: Production Workspace already exists

I was recently asked how do you use the Deployment Pipelines for Dev/Test/Prod if you already have a production workspace. What happened to this user when they created the Deployment Pipeline, the existing workspace was select for Development…

Read More »

Power BI Goals

Another great feature (in preview) for Power BI. It is like a scorecard with functionality to help someone track progress. Whether it be sales goals or research successes, power BI goals can help.   I really like the…

Read More »