Tag: DirectQuery

DirectQuery Connection in Power BI; How does it work? Limitations and Advantages

Posted on by Reza Rad

In the last post, you learned about Import Data or Scheduled Refresh as a connection type. In this post, you’ll learn about the second type of connection named; DirectQuery. This type of connection is only supported by a limited number of data sources, and mainly targets systems with a huge amount of data. DirectQuery is Read more about DirectQuery Connection in Power BI; How does it work? Limitations and Advantages[…]

Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings

Posted on by Reza Rad

With the DirectQuery to Power BI or Azure analysis services dataset, there are some limitations on the way that RLS (Row-level security) works. Considering that I have written a book and many blogs on this subject, It was fair to have a look at how this works. In this blog and video, you will learn Read more about Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings[…]