Using Power BI Embedded you can integrate your report in a website or web-application. To do so there are three parts you need to do: Configure your Azure environment Add a Power BI workspace to this environment and upload a report Implement the code to generate a token and embed your report In this post
Continue reading...
As you might know, I'm keeping an eye on how I can automate my Data Warehousing testing. In "Automated Testing for the Data Warehouse" my observation was In essence, testing a Data Warehouse isn't that complex It turns out I'm not the only one thinking about this (really? 😉 ). Some time ago I listened to
Continue reading...
One of the cool new features of SQL 2016 or SQL Azure is that you can add row level security to your database directly. So you don't need to use a cube or a tabular model to implement row level security. Let me show you how you can use it. The example is based on
Continue reading...
Just recently I was writing a very complicated query. Took me 2 hours to write. In the end I saved it as a view in the development database. I did not yet synchronize it back to the solution in visual studio, because I wanted to add a few related views for the problem I was
Continue reading...
The idea of organizational Business Intelligence was to create "One version of the truth, One Ring version to rule them all" errrr, well that was the idea. Away with all those Excels and bring on the conformed BI reports right? Of course it is a great idea to make sure you have a data warehouse where your data
Continue reading...
You may have experienced it: your report was working just fine, untill you published a database change and oops! a report doesn't work anymore. Especially when you have about 70+ reports running their own queries, this can be a pain. Why would a report contain a query? Well, because it is easy, quick to develop,
Continue reading...
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...
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...
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...
This Christmas holiday, I read Alberto Cairo's "the functional art" - a must-read if you're interested in data visualization at any level. In the fourth part of the book he includes some interviews with leading people in the data visualization field. Especially in the interviews with Hannah Fairfield (at the time of the interview Graphics
Continue reading...