How to create a service principal to automate Fabric

Service Principals are essential to using the Fabric REST API for automation. In this blog well show you how to create a service principle that can be used to automate API calls to PowerBI such as refresh. Once you have created the service principle the next article shows you how to use the service principle to … Continue reading How to create a service principal to automate Fabric

Sequential Identity in Fabric

Why do we need sequential identity in data warehousing? Currently Fabric doesnt support Identity columns. Even if/when it does, I assume that the numbers won't be sequential as most MPPs such as SqlPools generate different ranges per "node" as per Synapse, resulting in numbers that may be unique but look somewhat random. https://azurede.com/2021/07/31/comparing-sql-server-and-synapse-analytics-identity-columns/ First up, … Continue reading Sequential Identity in Fabric