How to use the Microsoft Face API in PowerBI

Using Cognitive Services as part of PowerBI dataflows has been made really easy, as long as you have Premium or Embedded capacity. But if you have only Pro/Free account or you need the Face Recognition API, then you need to work some ...

SQL Server 2019 Discovery Day wrap-up

За четвърта поредна година конференцията SQL Server Discovery Day събра технологичната общност и представи новите тенденции и предстоящи възможности на излизащата в края на годината версия – SQL Server 2019. Покрити бяха теми, ...

Changing Analysis Services Database Compat to 1470 in SQL 2019 CTP

If you want to evaluate the new features in Analysis Services 2019 CTP like calculation groups, the first thing you need to do is change your compatibility setting of the AS Tabular database to 1470. At the time of writing this ...

How to fix “The term ‘Invoke-ProcessASDatabase’ is not recognized”

Last week I needed to process an Azure Analysis Services model via Powershell and tried using the Invoke-ProcessASDatabase, as described here. On my server I have SQL installed, together will all the management tools I might ever need, ...

Reference architecture – traditional DWH with PowerBI as a visualization layer

Last year we started working with a customer to build a business intelligence system, that can increase their time to decision, by having reports and aggregations always ready. At the same time the customer wanted to enable ...

How to implement Role Level Security with Role Playing Dimensions in PowerBI

Role Playing dimensions are a common thing in BI scenarios and in the context of PowerBI, Reza Rad (blog|twitter) did an amazing job describing them. So if you want to learn how to implement them in your model, please visit Reza’s ...

Complete PowerBI Resource kit

Complete list of books and resources that we use on daily basis for our PowerBI projects.

TOP 6 announcements in the PowerBI world in March and April 2019 (so far)

As always, we are in the midst of very exciting times for BI professionals, especially the ones, dealing with Microsoft products. PowerBI is constantly being updated and new features are announced practically on weekly basis. In March and April 2019 those new features were quite a lot and in this blog post we will share our TOP 6, that can make a difference!