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