Select Page

What is wrong with Microsoft Text Analytics?

I have been working for more than a year now on Power BI integration with Microsoft Cognitive Services Text Analytics APIs, and the sentiment analysis in specific (You may have read my initial work on Microsoft Power BI blog here). I have been using the free tier,...

The Extension.Contents() M Function

Following on from my post last week about M functions that are only available in custom data extensions, here’s a quick explanation of one of those functions: Extension.Contents(). Basically, it allows you to access the contents of any file you include in the .mez...

Power Query Transpose Bomb

Earlier in my days as a cyber security software developer, there was a term called Zip Bomb here, for malicious Zip files that were meant to consume excessive memory when they are decompressed, and as a result create hangs and crashes to the process that decompressed...

Limiting SSIS to a Single File Type

A while ago I was having some issues with SSIS and moving files. There was a hidden file called thumbs.db When SSIS was running the move file task it would fail because it can’t place duplicate files in the same location. The thumbs.db file was the problem. Even...