Power BI implementations - Exeliq

According to Microsoft Power BI Performance Best Practices, placing many visuals in a single report slows report performance.
Limit widget visuals to no more than eight per report page and grids to no more than one per page. Limit pages to no more than 30 points (cards: 1, gauges: 2, charts: 3, maps: 3, grids: 5).
Limit tiles to no more than 10 per dashboard.

By default, all visuals on a report page can interact with one another. For optimal performance, interactivity should be controlled and modified.

Disabling unwanted interactivity reduces the number of queries fired at the backend and improves report performance.

Row Level Security restricts user access to certain rows in a database depending on the characteristics (role) of the user executing a query. With RLS, Power BI only imports data the user is authorized to view.

Combining Power BI roles with roles in the backend can result in substantial performance gains.

Test all roles before rolling out to production.

Power BI certified visuals are AppSource visuals that have passed rigorous quality testing. Microsoft verifies that certified custom visuals have robust and well-performing code.
Certified custom visuals are the only custom visuals that can be viewed in Export to PowerPoint and email subscriptions.

If you observe high page load times when using hierarchical filters, remove the hierarchical filters and instead use multiple filters for the hierarchy.

High Business Impact (HBI) data requires users to get a policy exception to share the data externally. Low Business Impact (LBI) and Medium Business Impact (MBI) data do not require exceptions.
By using Power BI data classification, you raise user awareness about the security level that should be used and how reports should be shared inside and outside the organization.

Personal Gateway takes data and imports it into Power BI.

Enterprise Gateway imports nothing, which is more efficient when working with large databases.

If the same gateway is used for Scheduled Data Refresh and Live Connection, Live Connection performance will slow down when Scheduled Data Refresh is active. Avoid this issue by creating separate gateways for Live Connection and Scheduled Refresh.

Custom visuals that are not certified are generally not thoroughly tested by the Power BI team. They might perform poorly when handling large datasets or complex aggregations. If a custom visual performs poorly, consider changing it to a different visual.

Push calculated columns and measures to the source where possible. The closer they are to the source, the higher the likelihood of improved performance.

Create calculated measures instead of calculated columns.

Use star schema for designing data models.

Slicers are a great way of allowing users to navigate data, but they come at a performance cost. Each slicer generates two queries: one gets the data, and the other fetches selection details.

Creating too many slicers impacts performance negatively.

With the tenant and data source in the same region, network latency is reduced. This results in faster data transfer and faster query execution.

Keep the model as narrow and lean as possible.

Power BI works on columnar indexes; longer and leaner tables are preferred.

Report cache refresh should be set to intervals similar to the data source refresh frequency.

By default, the Power BI cache frequency is set to one hour. If, for example, your dataset refreshes only once per day, you should update the cache frequency accordingly.