Power BI storage modes – Import vs Direct Query

When building datasets in Power BI, you have different options on how to connect and store the data in your model. There are two main modes to choose from when querying data from sources. These are import mode and direct query mode. Import mode allows you to import the data in your local dataset, and … Read more

Dimensional modeling for Power BI: The purpose of data modeling

Data modeling techniques and methodologies are a common discussion topic when working on BI or data warehouse projects. There are multiple practices of data modeling and different reporting tools support different ways to handle data. If you have past experience of working in the data area, chances are you have come across Kimball dimensional modeling, … Read more

Why you shouldn’t use Power BI “Publish to web” and what to use instead

In this blog post I will try and guide you through Power BI’s functionality Publish to web as well as the security aspects of sharing your data. How does it work, when should I and when shouldn’t I use it? What is it? Power BI’s Publish to web functionality has been widely used since it’s … Read more