Power BI apps and workspaces

One of the cool features of Power BI are workspaces. They make it possible to work together on reports, share information, share reports, share datasets, etc. You can add administrators and members. Members can be read-only, or report authors. I often see that members are set to be read-only. There is another way to have
Continue reading...

Row level security SQL and Power BI

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...

Recover the lost query

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...