Bob has broad experience designing and implementing Business Intelligence and Data Warehouse solutions on the Azure and Microsoft SQL Server platforms. He has spoken at SQL Saturdays and has presented webinars on various cloud architecture and data management topics.
Now that Power BI has released dataflows and with the ability to share datasets across reports in Power BI, we’ve been asked, what are the differences between dataflows and datasets and when should I use one vs the other? In this post I’ll discuss the similarities, differences, and use cases for Power BI dataflows and shared datasets.
Are you looking to reuse file connections you have set up in Azure Data Factory prior to using Data Flows? Maybe you have a case where you’re building some pipelines and you’re pulling data from files, etc. and you want to use reuse those for a Data Flow. When I tried this I discovered that you cannot reuse these existing text file data sets, but you must recreate them. In today’s post, I want to share a quick tip on how to recreate these file connections to use in Data Flows.
What is your disaster recovery plan for your Azure SQL Data Warehouse? Today I’d like to talk about disaster recovery in Azure SQL Data Warehouse, more specifically, about a feature that was released with Azure SQL Data Warehouse Gen2 called Geo-backup policy.
As you may know, Microsoft recently released Visual Studio 2019. Today I want to talk about how to install the Business Intelligence Designer which used to be part of SQL Server data tools. The way that we install these has changed in Visual Studio 2019, so I wanted to share this information.
I’d like to share a great resource that I found when setting up a demonstration of Azure SQL Data Warehouse. It’s a tutorial from Microsoft that allows us to very easily load a large sample data set into Azure SQL Data Warehouse for free.