Intro Many large organisations have a strategy to keep there data secure. Part of this strategy is to have firewall rules enabled on all data source. This complicates making a connection to an Azure data source in from Microsoft Fabric or Power BI. This article describes the options available to connect to a data source […]
Connect to data sources behind a firewall in Mircosoft Fabric Read More »
On 1 February 2024 the Virtual Network data gateway has been made General Available (GA). With the change to GA, also some settings of the VNet data gateway have changed. Now the VNet data gateway has to be assigned to a Premium or Fabric Capacity. Prerequisites Before creating or making changes to an existing VNet
Virtual Network (VNet) data gateway in Power BI Read More »
Microsoft Fabric has some options when it comes to the data layer. This video follows the history of each of the storage options and how they developed over time. Explorer and understand the main purpose of the warehouse, lakehouse, Kusto DB and Semantic model of the Microsoft Fabric data layer. Watch my video on YouTube
Evolution of Microsoft Fabric data layer Read More »
What is the error message There are two messages that have the same cause. When opening the setting of a semantic model there is the message: “This semantic model was disconnected from data sources when it was edited by a user who wasn’t authorized to use the data connections. ” After publishing a Power BI file
How to fix “Semantic model was disconnected” Read More »
Having data protected is an important aspect of any Reporting tool. In this blog is explained how Row Level Security is set up so a user can only see the data it is entitled to see.
Power BI Row Level Security Read More »
Welcome to the new weblog for Datalexure. Here you can find my posts on Power BI, SQL server and Azure data platform. Some articles have previously been posted on datahelden.com. This site is not active anymore.
Welcome to Datalexure Read More »
Kerberos voor SQL Server (deel 2) : Resource based constrained delegation In deze blog over Kerberos aandacht voor ‘Resource based constrained delegation’. Dit is een nieuwe methode voor Kerberos delegations welke voor grotere BI projecten een interessante oplossing kan zijn. Het grote voordeel is dat het eenvoudiger is te configureren en zelfs via een AD
Resource based constrained delegation Read More »
Als je meerdere servers in je serverpark hebt staan krijg je te maken met het “double hop scenario”. Kerberos wordt gebruikt wanneer een gebruiker vanaf zijn eigen systeem een connectie maakt naar server 1 en dat server 1 op zijn beurt weer resources gebruikt van server 2. Het is daarbij noodzakelijk om de user credentials
Kerberos voor SQL Server Read More »
