Published in Rik in a Data Journey·May 20Bulk extract M code from Power BI datasetsTabular Editor and nothing else — Prelude Your company deeply adopted Power BI and now you have many Power BI datasets published on Power BI service. Each of these datasets can have multiple tables and you want to analyze how data are extracted and prepared from the sources. …Power Bi4 min read
Published in Rik in a Data Journey·Apr 7Arrow Library Installation Error on Databricks ClusterLook to the CRAN… — One week ago a customer contacted us asking for any advice about an issue impacting his Databricks based application. In this super short blog post I’m describing how we came out of it. The customer built a data engineering solution reading and writing parquet files in Python notebooks run on…Databricks2 min read
Published in Rik in a Data Journey·Feb 6Connect Power BI to Storage Account using Shared Access SignatureI thought “Easy!” but… — Prelude Azure Storage Account is a solution widely used to store data that could be used in analytics pipelines. Each Storage Account has 2 keys that can be used to access its containers and they gave full control. Every application that needs to access data in a Storage Account must be…Power Bi5 min read
Published in Rik in a Data Journey·Dec 5, 2021Lockdown your Power BI — Azure SQL Connection with VNet Data GatewayAzure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and…Power Bi6 min read
Published in Rik in a Data Journey·Aug 14, 2021ADF Managed Identity connection to ASQL leveraging AKVIf you’re working on Azure you surely use Azure Key Vault and if not you definitely should. Azure Key Vault is a cloud service that lets you to securely store and centralize your secrets on Azure. You could store API keys, passwords, certificates, connection strings, cryptographic keys etc. This approach…Azure Key Vault3 min read
Published in Rik in a Data Journey·Jul 21, 2021Comparing Azure Data Factories exporting all the componentsPrelude Some days ago a new customer came to us asking to do some implementations on their Azure Data Factory pipelines. Before starting we realized they’ve two different ADF resources, one for Dev/Test purposes and the other one for Production. “I assume they’re perfectly aligned, and therefore changes won’t introduce regression…Azure Data Factory4 min read
Published in Rik in a Data Journey·Feb 26, 2021Authentication methods and SSO explained in Paginated ReportsLast Tuesday I had the pleasure of teaching a “Paginated Reports in A Day” (aka PRIAD) workshop sponsored by Microsoft. It’s been a really stimulating class with a lot of questions on Paginated Reports design and how to correctly integrate them into Power BI ecosystem. During the workshop attendees create…Power Bi3 min read
Published in Rik in a Data Journey·Feb 3, 20212020: One Year of CO…mmunityCOVID changed data communities — On February the 19 it’ll be one exact year of smart working for me due to COVID pandemic. I was used to travel to attend or to speak at community events but due to COVID this changed a lot, especially in Europe. For months we haven’t been allowed to move…Power Bi2 min read
Published in Rik in a Data Journey·Dec 30, 2020Is that a bug or a feature? ADF on Power BI dataflows CDM folderI’m sure you already know Power BI dataflows behind the scenes save data in Azure Data Lake Storage Gen. 2 managed by Microsoft by default, in CDM folders. In a previous post I’ve described how you can setup your Power BI dataflows to write into your own ADLS giving a…Data Factory5 min read
