Yes, you read it right. Most security implementations on data estates are a joke. It's just closing your eyes for what you can't see or don't feel responsible for. Too often I come across situations where the lack of security awareness and proper implementation results in locking the front door but leaving the back door …
Obviously, you don't want to start every solution from scratch. Therefore, it might be beneficial to kick-start your new solution by just importing components you already developed at earlier stages. Recently, I wanted to import a notebook to a Fabric workspace but was a bit confused. In this blog, I will further elaborate on the …
Continue reading Importing items to Fabric workspaces sounds easier than it is
A long time ago, I blogged about Power BI governance with topics like feature implementation in a phased approach and why you should consider to disable export to Excel. In this blog, I want to continue the governance topic with another blog about why monitoring your tenant is important! This blog will also provide you …
Imagine you have a semantic model in the Power BI Service (or Fabric if you will), and you're about to make a breaking change to this semantic model. How do you inform your end users? How do you tell them about this change? In this blog I will zoom in to options you have in …
Continue reading Full Impact Analysis in Power BI, Export and Analyze in Excel
Have you ever wanted to sync two slicers on a report page? Even when both slicers are coming from different dimensions? A lot of users end up setting the relationships to bi-directional (both) which has huge side effects! You may up with a ambiguous data model, over filtering fact tables and wrong results. Also, there …
Continue reading Sync two slicers without bi-directional relationships in Power BI
Last week, I had a situation in which a client wanted to purchase a reserved instance Fabric capacity. Me being me, I assumed it would be super straight forward to purchase through Azure. However, at some point I was lost in the process where the official documentation confused even more. In the end, I figured …
Continue reading Purchasing Fabric Capacities as Reserved Instance
There are tons of options in Power BI to add your custom logic. Varying from SQL expressions at data ingest all the way up to Visual Calculations to add logic on a visual level. But how do they compare to each other, where should you do what? As I've been a fan of making DAX …
Continue reading Comparing calculation options in Power BI, including Visual Calculations
Recently, I wrote a blog about the new branch-out feature in Git connected Fabric and Power BI workspaces. In this blog, I will continue the topic of Git integration by discussing various setups you could consider in your Git integration, deployment and release strategies as part of your continuous integration and continuous delivery setup. Will …
Continue reading Fabric CI/CD with Git deployment and release strategies
Yesterday, Microsoft released a new option called "branch-out" that allows you to easily setup a new branch from an existing Fabric workspace. Obviously, this was already possible but involved a lot of manual work. With this new option, you can create your own feature branch to work in isolation before you commit your work to …
P-SKUs, A-SKUs, EM-SKUs and now we also have F-SKUs... all these different capacities that are out there today each have their own specifics. Lately, I've been in a lot of conversations around Fabric capacities. There seems to be some unclarity around what you pay for in the end and how it compares to Power BI …
Continue reading Power BI and Fabric capacities: Understand the difference and cost structure
Data - Marc 