Hi, The document available for download from the following link details an approach and considerations in monitoring the On-Premises Data Gateway (formerly Power BI Enterprise Gateway):
Category: Power BI
Role-Based Default Filter Context for Power BI
Update (9/26/2017): An improved approach to dynamic (user role based) default filter context for Power BI is detailed in Chapter 8 of the Microsoft Power
SSAS Tabular 2016: Direct Query vs. In-Memory
Hi, With the release of SSAS 2016 last month I’ve been thinking about the enhanced Tabular Direct Query mode and the trade-offs with In-Memory mode (default).
Dynamic Filter Context Messaging for Power BI and SSAS Tabular
Summary A user’s filter selections and the filters applied at the report level (not visible to the user) can be computed via DAX functions and then exposed
DAX Variables Design Considerations
Summary DAX variables can be used to optimize performance of queries against SSAS Tabular, Power BI Desktop, and Power Pivot for Excel models by re-using a DAX expression multiple times
Always Be (thinking) Columnar Part II – FILTER()
Summary: You can raise the performance of your DAX code by applying filters in a sequential order from the most selective to least selective. The goal is