Bob Rubocki

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.

Power BI Dataflows vs Shared Datasets

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.

Bob RubockiPower BI Dataflows vs Shared Datasets
Read More

Creating New Azure Data Factory Data Flow File Data Sets

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.

Bob RubockiCreating New Azure Data Factory Data Flow File Data Sets
Read More

Visual Studio 2019 BI Design Tool Extensions

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.

Bob RubockiVisual Studio 2019 BI Design Tool Extensions
Read More