Exciting data platform announcements at Microsoft Ignite 2019

All data platform announcements from the first day at Microsoft Ignite 2019!

SQL&BI User group meeting October ’19

The October meetup for Bulgaria’s SQL&BI Group was held last night and it was an amazing experience as usual. The topic was datawarehouse modeling and in particular – covering the basics. The topic is indeed something ...

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.