---
title: "Josef Richberg (@josefrichberg) | Hashnode"
description: "Principal Data Architect, Azure @ Penguin Random House. Read the latest articles by Josef Richberg on Hashnode."
url: "https://hashnode.com/@josefrichberg"
---

@josefrichberg

# Josef Richberg

@josefrichberg · Pennsylvania, US · Joined October 2022

Principal Data Architect, Azure @ Penguin Random House

[Website](https://josefrichberg.com/)

### [Analysis Services models in Azure Fabric -- METADATA$ROW\_ID gotcha](https://josefrichberg.com/analysis-services-models-in-azure-fabric-metadatarowid-gotcha?utm_source=hashnode&utm_medium=feed)

For those of you entering the Microsoft Fabric foray, there is a big caveat you must be aware of. If you are using Fabric Mirroring or Delta Lake tables you will see an additional column in your data source: METADATA$ROW\_ID. This column is added auto...

2 min read · [josefrichberg.com](https://josefrichberg.com/analysis-services-models-in-azure-fabric-metadatarowid-gotcha?utm_source=hashnode&utm_medium=feed)

[Sep 8, 2025](https://hashnode.com/posts/analysis-services-models-in-azure-fabric-metadatarowid-gotcha/68bf2ff7ae5e82143e6d2554)

### [Permissions required for user defined table types in Microsoft SQL Server](https://josefrichberg.com/permissions-required-for-user-defined-table-types-in-microsoft-sql-server?utm_source=hashnode&utm_medium=feed)

This has bitten me so many times, I’m putting this here where I can find it in the future. You might want to bookmark this page :) I rely heavily on stored procedures for interaction both internally and externally. The improve performance and efficie...

1 min read · [josefrichberg.com](https://josefrichberg.com/permissions-required-for-user-defined-table-types-in-microsoft-sql-server?utm_source=hashnode&utm_medium=feed)

[Jun 25, 2025](https://hashnode.com/posts/permissions-required-for-user-defined-table-types-in-microsoft-sql-server/685c1a71ace297c4ebf952fe)

### [Azure Data Factory utcNow() nuances](https://josefrichberg.com/azure-data-factory-utcnow-nuances?utm_source=hashnode&utm_medium=feed)

For those of you who work with Azure Data Factories I thought I’d help you out with, what I would consider a bug in how pipelines work. For the record, I work with pipelines on almost a daily basis, but I am generally pushing data into Microsoft SQL ...

2 min read · [josefrichberg.com](https://josefrichberg.com/azure-data-factory-utcnow-nuances?utm_source=hashnode&utm_medium=feed)

[Jun 3, 2025](https://hashnode.com/posts/azure-data-factory-utcnow-nuances/683f2fd48ad6fbaa303c19e3)

### [Microsoft SQL Server permission chaining](https://josefrichberg.com/microsoft-sql-server-permission-chaining?utm_source=hashnode&utm_medium=feed)

Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta...

1 min read · [josefrichberg.com](https://josefrichberg.com/microsoft-sql-server-permission-chaining?utm_source=hashnode&utm_medium=feed)

[Jun 2, 2025](https://hashnode.com/posts/microsoft-sql-server-permission-chaining/683d3acfd427aab4346e0d6c)

### [Using a stored procedure as a source for PowerBI Paginated reports](https://josefrichberg.com/using-a-stored-procedure-as-a-source-for-powerbi-paginated-reports?utm_source=hashnode&utm_medium=feed)

If the reports that you are building do not need to be interactive, you can use Microsoft Paginated Reports (or SSRS). One of the benefits of a paginated report is that it’s source(s) can be stored procedures. I really, really like that option.In Mic...

2 min read · [josefrichberg.com](https://josefrichberg.com/using-a-stored-procedure-as-a-source-for-powerbi-paginated-reports?utm_source=hashnode&utm_medium=feed)

[May 22, 2025](https://hashnode.com/posts/using-a-stored-procedure-as-a-source-for-powerbi-paginated-reports/682f5fd686d25b5d401ddc6a)
