Azure Data Factory, first thoughts

I have been trying out Azure Data Factory. You can wonder if ADF is more like SSIS in the cloud or SQL Server Agent in the cloud. It does not quite feel like a pure ETL tool. Coming from SSIS on premise this is a completely different experience. My first impression is that the UI is
Continue reading...

VSTS Continuous MSBuild for DWH / BI

Wait, didn't I post this already several weeks ago? Well, almost. A few weeks ago, I showed how to set up a build agent using devenv.com. Unfortunately, I ran into some problems like failing builds not reporting failure and SSAS Tabular projects not building correctly. However, it turns out to be pretty easy to build
Continue reading...

VSTS Continuous Build for DWH / BI

In my earlier post "Automated Deployments using Visual Studio" I metioned that the method described was a workaround because I hadn't figured out how to do a continuous build in VSTS (Visual Studio Team Services) yet. With hindsight, that workaround was not really needed: VSTS build turns out to be só easy, that it's ridiculous
Continue reading...

Looking for intern / grad student: Continuous Integration for BI

As you might've noticed, I'm keeping an eye on Continuous Integration for Business Intelligence. Currently, I'm looking for a grad student to help me implement CI inside BI in his/her internship. As we're located in Holland, speaking Dutch is a prerequisite - but as a bonus, you'll be able to share your findings in English
Continue reading...

Sharing your Power BI reports

If you are using Power BI, you may want to consider how you are going to share your reports and dashboards. Should you share your dashboards? Should you use groups or content packs? There are several ways to do this.   Share your Dashboards: open your dashboard and click on the "Share" Icon. Your recipients
Continue reading...

Power BI desktop or online?

When you are creating Power BI reports. Do you develop them online or in desktop mode? If you are doing pure self service BI for quick prototyping, it doesn't matter all that much. However, if you use live connections, you may want to use Desktop since you can easily switch between test and production servers.
Continue reading...

Your data is going places

There are still a lot of people who do not believe BI and cloud go together. "My data is too valuable to store anywhere else but on premise!". Most of the times we are talking about gut feeling here. It is not a strange thought either. But the funny thing is: maybe your data is
Continue reading...