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 »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 »Power BI Summit April 19-32 (Virtual)
The next virtual summit coming up is April 19-23, 2021. It is called Power BI Summit and is hosted by Radacad. There are MVPs, Microsoft employees and Power BI experts from all around the world sharing almost every…
Read More »Power BI XMLA Endpoint Read/Write GA
On Jan 5th, it was announced that Power BI Premium supports Read/Write XMLA endpoints is now GA. This allows tools to connect to and manage the analysis services engine in Power BI Premium. This goes a long way…
Read More »