dataMinds News Round up –
March 2024
With the release of semantic link v0.6, developers are given the ability to find dataset optimization opportunities across workspaces. Sandeep Pawar elaborates on how to calculate & reduce the Power BI semantic model’s (formerly known as dataset) size using semantic link!
Doesn’t semantic link ring a bell? Will Needham got you covered with a 1-hour semantic link deep dive.
The more you monitor something the more likely it is that you’ll see something strange you can’t explain. Seeing DAX queries run in the middle of the night by people who were definitely not online at the time is something you might’ve encountered already. What is the cause – hackers? Ghosts? In a lot of cases the culprit is actually Power BI’s query caching feature. Chris Webb walks the talk.
Join Patrick as he explores Real-Time Analytics (RTA) in Microsoft Fabric by creating an event stream into a KQL Database. It only takes a few clicks!
Need to extract ZIP files and don’t want to write code? Adam walks you through how you can do this with Pipelines and dataflows within Microsoft Fabric. A NO CODE approach!
When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function.
USERELATIONSHIP is a very common and helpful function, used whenever there are multiple relationships between tables and developers need to decide which relationship to use. However, in some scenarios, this common function raises an annoying error:
The UseRelationship() and CrossFilter() functions may not be used when querying ‘Sales’ because it is constrained by row-level security.
As with all the error messages, this requires some understanding and further explanation. Moreover, a workaround is straightforward to find. However, the workaround has some subtle restrictions that need to be well understood. Who else than Marco Russo & Alberto Ferrari are shining their light on this topic? This article & webinar takes on the issues, provides a workaround, and its restrictions.
The Azure Kubernetes Fleet Manager is an invaluable addition to the Azure Kubernetes Service cluster management in Azure and makes the Kubernetes version upgrade a breeze, as well in combination with already existing infrastructure as code configurations.
Besides the Kubernetes version upgrade capabilities, the Fleet Manager can also replicate and maintain Kubernetes resource objects when running the Fleet Manager with the hub cluster configuration. Daniel Neumann walks you down Azure Kubernetes Fleet Manager’s alley!
If you ever want to have a general report for sales for all countries, and then you want every morning the report to be sent (as PDF or PowerPoint alongside the link to the report) to representatives of each country, the report with the data filtered for their country only, then Dynamic Subscription in Power BI is the feature you need to use. Previously, this was called a Data-Driven Subscription in SSRS (SQL Server Reporting Services). In this article and video, Reza Rad explains how to use this feature using an example and what you need to know about it.
