In my previous post I explained how to enable row level security on your SQL database. However, if you use Power BI as a live connection to your database, it will filter according to the user that is used in the data gateway. This effectively means that you cannot rely on sql row level security
Continue reading...
With Continuous Integration working for my Data Warehousing solution (SQL Server, SSAS Tabular, SSIS), it's time to step forward. Before moving to Continuous Deployment, I want to have a rigorous and automated testing on my EDW. But how to get there?
Continue reading...
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 last
Continue reading...
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...
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...