Author: admin
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 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 »