Automating Power BI Semantic Model Security with Fabric Semantic Link

You may be using standardized solutions like Fabric Unified Admin Monitoring (FUAM) or any other templated solution that comes with a semantic model. As part of transparency within your organization, you decided to share the insights gathered with others in the organization by adjusting the solution to apply your own security setup on top. However, …

Continue reading Automating Power BI Semantic Model Security with Fabric Semantic Link

Your Metrics, Your Rules: Extracting and Storing Fabric Admin and Capacity Metrics Data in Fabric

There are loads of default semantic models and reports provided within Microsoft Fabric and Power BI. Take for example the capacity metrics, or all reports made available in the Admin Monitoring Workspace. However, all these solutions come with the same downside, being the data is available for a very short timeframe only. Capacity metrics only …

Continue reading Your Metrics, Your Rules: Extracting and Storing Fabric Admin and Capacity Metrics Data in Fabric

Automatically populate Data Agents with Semantic Model Synonyms

It was only yesterday, that I wrote a blog post on Semantic Models as a source for Fabric Data Agents. Not much time has passed, since I learned that Fabric Data Agents does not (always) respect the Synonyms that have been added to a Semantic Model. As a result, the Data Agent may start creating …

Continue reading Automatically populate Data Agents with Semantic Model Synonyms

Dynamically refreshing (historical) partitions in Power BI Incremental Refresh Semantic Models using Fabric Semantic Link

I've heard the question pretty often from customers: "You told me to use incremental refresh, but how can I regularly run a full load or refresh onder partitions?" Well, there are perfect ways to do this using Tabular Editor or SQL Server Management Studio. But this often includes manual work to trigger the processing. Today, …

Continue reading Dynamically refreshing (historical) partitions in Power BI Incremental Refresh Semantic Models using Fabric Semantic Link

Orchestrate Power BI Semantic model refreshes through Fabric Pipelines

Recently, Microsoft released a new activity type to trigger Power BI Semantic Model refreshes. A great step forward to have a native pipeline activity and no longer need to setup complex steps with APIs and authentication manually. Or is there still a case? In this blog I will elaborate on what this new Pipeline activity …

Continue reading Orchestrate Power BI Semantic model refreshes through Fabric Pipelines

Exploring Direct Lake Framing and warm-up data using Semantic Link in Fabric Notebooks

In the previous blog, I wrote about data temperature as part of Fabric when you're using Direct Lake storage mode. In that blog, I explained how you can get insights in the temperature of a column, what that temperature means and what the impact of the temperature is on columns that are queried more often. …

Continue reading Exploring Direct Lake Framing and warm-up data using Semantic Link in Fabric Notebooks