NolockHow to Connect an Azure Synapse Analytics Workspace / ADF to an ADLS Gen 2 (Cross-Tenant)Lucky you if you work for a company which has just one tenant. Then, if you have a storage account with an activated firewall, you can…10 min read·Aug 16, 2021----
NolockWarning: The Dataset Is under MaintenanceWhen I was developing a new dataset, which was going to be referenced by many hundreds of reports, I wanted to be able to tell the end…2 min read·Mar 8, 2021----
NolockHow-To: A Table for Custom Report MeasuresIn this short blog post, we will learn how to create a separate table for measures which are developed by citizen developers when creating…3 min read·Mar 8, 2021----
NolockParquet, ADLS Gen2, ETL, and Incremental Refresh in one Power BI DatasetA year ago, I was developing a solution for collecting and analyzing usage data of a Power BI premium capacity. There were not only some…8 min read·Mar 8, 2021--2--2
NolockInternals of Copy & Paste in Power Query EditorToday I will deep dive into an elementary feature called Clipboard. You use it probably hundred times a day using the keyboard shortcut…5 min read·Mar 6, 2021----
NolockLookup Table in Power QueryI have prepared an article about a transitive closure in Power Query. I wanted to publish the article already, but I decided to wait a…4 min read·Mar 6, 2021----
NolockPower BI Incremental Refresh with ETLI’ve been testing incremental refresh for more than half a year in an enterprise environment and I’d like to share my experience with this…7 min read·Mar 6, 2021----
NolockHow To Discover Undocumented Theme Settings in Power BI DesktopOne of the many benefits of Power BI is the possibility to create your own theme file, which defines many design properties of a report…4 min read·Mar 4, 2021----
NolockHow-to: Dynamic Pivot in Power Query / T-SQLRecently, I have been faced with a challenge of pivoting many tables. Every table was completely different, I needed some preprocessing…3 min read·Mar 4, 2021----
NolockHow-To: Convert UTC to Your Local Time Zone in Power QueryIs there a simple way to convert a timestamp in UTC to your local time zone in Power Query? Yes and no. Let’s find out what the options…5 min read·Mar 4, 2021--1--1