How 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…Aug 16, 20211Aug 16, 20211
Warning: 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…Mar 8, 2021Mar 8, 2021
How-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…Mar 8, 2021Mar 8, 2021
Parquet, 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…Mar 8, 20212Mar 8, 20212
Internals 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…Mar 6, 2021Mar 6, 2021
Lookup 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…Mar 6, 2021Mar 6, 2021
Power 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…Mar 6, 2021Mar 6, 2021
How 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…Mar 4, 2021Mar 4, 2021
How-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…Mar 4, 2021Mar 4, 2021
How-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…Mar 4, 20211Mar 4, 20211