How Bookmarks at Power BI can save performance at the underlying data source. The following article describes how it works: Bookmarks and Performance
Some thoughts/clarifications about the Power BI / Data Gateway (personal mode)
In the last time a customer has installed the Data Gateway in the personal mode and he was very confused about:
- The managing at the powerbi.com Portal
- … and the direct query / live connection possibilities
So, here some clarifications about the Gateway in the personal mode:
- You don’t see the Gateway under Data Gateways at the powerbi.com portal!
You can manage the connection and the credentials in the dataset from a report in den schedule refresh properties. The gateway is only at the enterprise mode to manage!
- Direct Query is not possible! You can only do a refresh for the import mode.
For more information please visit https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
The following article will describe how to you the Power BI Composite Model. Also I will describe the filtering at Direct Query.
–> Article Power B Composite Model