by Melissa Coates | Jun 16, 2019 | SQL Chick
This post is to make you aware that there are some serious downsides when you choose to create reports in the Power BI Service rather than Power BI Desktop. The Short Version of the StoryI always recommend to Power BI authors that report creation & editing should...
by Melissa Coates | Mar 29, 2019 | SQL Chick
Dataflows in Power BI are a really interesting capability for centralizing and reusing Power Query logic among many different PBIX files. If you’ve found yourself copying M scripts (Power Query formula language) between files, or creating a library of M scripts then...
by Melissa Coates | Mar 10, 2019 | SQL Chick
Now that Azure Data Lake Storage Gen2 is now based on Azure Storage as its foundation, we have a new level to incorporate into our planning process the file system itself. The file system contains the files and folders, and is equivalent to a container in Azure Blob...
by Melissa Coates | Feb 27, 2019 | SQL Chick
A couple of people have asked me recently about how to ‘bone up’ on the new data lake service in Azure. The way I see it, there are two aspects: A, the technology itself and B, data lake principles and architectural best practices. Below are some links to...
by Melissa Coates | Feb 18, 2019 | SQL Chick
Since I started focusing primarily on Microsoft BI/DW/analytics around 2005, I’ve always been happy being a generalist within that space. Fast forward to around 2017 when I started focusing predominantly on Azure. Being a generalist (still within...
by Melissa Coates | Jan 21, 2019 | SQL Chick
This post covers several things I’ve heard or been asked recently about organizing data in a data lake. Q: Partitioning by date is common. Where should the dates go in the folder hierarchy?Almost always, you will want the dates to be at the end of the folder...
